新聞財經娛樂♬資訊 News Economy

duncanb7, I open the VBA editor in Excel and copy and paste his 32-rows long VBA. But you can see on this screencast there are many different windows opened after I've pressed ALT and F11:

http://screencast.com/t/RO2c28oW

So I don't know how to save the Excel as macro-enabled (ok, I know which file extension to choose, but among all the opened windows, how do I get to the save-options and how to save?), and I don't know in which window to copy the VBA to and what to do with all opened windows. It's confusing.

see attachment file of junk.xlsm

Duncan

Click Insert on Excel,  click Sharp and draw circle or rect shape you like, and click the sharp
by mouse right-click and edit text for a word of "Reset"  and click "assign macro" to the Reset_values() sub

Duncan

Be Reminded, you have to save your file into xlsm format that is
Excel's macro-enabled file.  SO it is xlsm file not xlsx


Duncan

Please follow steps

1- Click insert and click modules on VBA editor and copy his macro on macro1 into your macro1 including "option explicit" that is reset all cell color to white
2-Copy everything in his sheets in Viktad rankning" into your similar sheet
3- Create button if you want called "Reset" that will call Reset sub in the sheet to
reset color from yello to white.


DUncan

MacroShadow, I tried your Excel suggestion, but it didn't work: I changed highlighting, but the total remains the same all the time. And Reset button is missing, so I can't reset to zero.

Ok duncanb7, it's no problems hiding the column in Excel, I did that. I think that is what Glenn did also.

On Column B, you just click B column, and then mouse right click, there is option call "hide" you can click it to  hide the whole column B. I think he didn't use macro VBA code to hide column, just manually made it

Duncan

How is this.

Yes, I think that's what Glenn did because he added a column B which he then hide (in his solution Excel, there are column A and column C visible only, not column B).

You want to hide the Column B if VBE Editor is opened, Right ?

Duncan

Ok, here is my Excel file attached (I've inserted the extra column B that I want to be hidden after VBA has been entered there).

If you send us your Excel file, that will be easier for comunication.
Take sometime to use VBA editor or Excel option.

Duncan

On VBA editor, there is  save button and you can save it in Excel, both are same

Yes, the option for entering VBA in Excel 2007.

Thanks, so I copied and pasted Glenn's VBA now into the VBA editor. How do I save this?

By the way, I did like Glenn did and inserted a new column to the right of column A, then placed the cursor in cell B1 and entered Glenn's VBA. After I've saved the VBA I will hide column B (like Glenn did).

What you mean, option and enter VBA ? (enter VBA on Excel 2007 ,just  press alt+F11)

Duncan