Hello,
I am trying to find a way to record a macro that would allow me to first unhide a worksheet, make edits to that worksheet, and then hide that worksheet when it is done. It sounds simple, but somehow when I tried doing that by recording the macro the sheet that I want to be hidden at the end of the macro needs to be unhidden before the macro is executed, which defeats the purpose.
I don't want anyone to be able to see that worksheet or what the macro did to it at any time.
Can someone help me?
Configuration: Microsoft Excel 2003
'excel macro' 'copy data from single text file to excel' Cannot unhide hidden files in vista Excel macro assign integer to read cell Excel macro compare worksheets of column a if matches copy the data to sheet1 next column Excel macro hide rows Excel macro new Excel macro paste shift:=xlup Excel macro range selection Excel macro shift:=xlup Excel macro split string Excel macro submit button add Excel macro to copy data from one sheet to another Excel macro validation list formula1 range Get blank cells count in a column excel macro How to select rows in a excel macro Insert lines excel macro Need excel macro to open hyperlink to file Pdf excel macro