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 compare 2 files Excel macro compare cell Excel macro delete row Excel macro fill a range of selected cells Excel macro for beginners Excel macro for date conversion Excel macro format.number Excel macro insert a new row where user wants Excel macro insert one blank rows Excel macro max in range Excel macro object variable or with block Excel macro range Excel macro replace error not found Excel macro selection.find Excel macro to check whether any values in a range < 0 Hiding file extension with excel macro How to write excel macro using if condition for a cell value equal to How unhide hidden iso files