ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro for Hiding Visible Worksheet (https://www.excelbanter.com/excel-programming/315243-macro-hiding-visible-worksheet.html)

LDanix

Macro for Hiding Visible Worksheet
 
I am new to programming in VBA. I need help with code for hiding the current
worksheet.

Frank Kabel

Macro for Hiding Visible Worksheet
 
Hi
just record amacro while doing this manually.

or use something like
activesheet.visible=false


--
Regards
Frank Kabel
Frankfurt, Germany


LDanix wrote:
I am new to programming in VBA. I need help with code for hiding the
current worksheet.


Tom Ogilvy

Macro for Hiding Visible Worksheet
 
ActiveWorksheet.Visible = xlSheetHidden

--
Regards
Tom Ogilvy

"LDanix" wrote in message
...
I am new to programming in VBA. I need help with code for hiding the

current
worksheet.





All times are GMT +1. The time now is 09:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com