Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to copy hidden sheet to front of tabs?
I've often thought this would be handy. If there was a macro that
would make a copy of the hidden main sheet, users would be much, much less likely to somehow overwrite the blank main sheet. Can this be done, though? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to copy hidden sheet to front of tabs?
If the sheet is hidden rather than very hidden, you can copy it:
Worksheets("Main").Copy After:=Worksheets(Worksheets.Count) If it is very hidden you might try Appliction.ScreenUpdating = False Worksheets("Main").Visible = xlSheetVisible worksheets("Main").copy After:=Worksheets(Worksheets.count) Worksheets("Main").Visible = xlSheetVeryHidden Application.ScreenUpdating = True -- Regards, Tom Ogilvy "StargateFan" wrote in message ... I've often thought this would be handy. If there was a macro that would make a copy of the hidden main sheet, users would be much, much less likely to somehow overwrite the blank main sheet. Can this be done, though? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy and Paste Macro for front totals sheet | Excel Discussion (Misc queries) | |||
How can I find/unhide hidden excel sheet tabs on a worksheet? | Excel Worksheet Functions | |||
Sheet tabs are hidden...option is checked | Excel Discussion (Misc queries) | |||
copy from hidden sheet | Excel Programming | |||
Locking Sheet Tabs as Hidden | Excel Programming |