View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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?