ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Hide Worksheets? (https://www.excelbanter.com/excel-programming/378776-re-hide-worksheets.html)

Don Guillett
Hide Worksheets?
 
At least ONE worksheet must be visible

--
Don Guillett
SalesAid Software

"Mark J" wrote in message
...
here is a copy of my code , but when i open workbook , "P001" is still
open
in background, any ideas?

Private Sub Workbook_Open()
Sheets(["PS001"]).Visible = False
Sheets(["PS002"]).Visible = False
Sheets(["PS003"]).Visible = False
UserForm1.Show
End Sub

Don Guillett
Hide Worksheets?
 
Glad to help

--
Don Guillett
SalesAid Software

"Mark J" wrote in message
...
Thank You.

"Don Guillett" wrote:

At least ONE worksheet must be visible

--
Don Guillett
SalesAid Software

"Mark J" wrote in message
...
here is a copy of my code , but when i open workbook , "P001" is still
open
in background, any ideas?

Private Sub Workbook_Open()
Sheets(["PS001"]).Visible = False
Sheets(["PS002"]).Visible = False
Sheets(["PS003"]).Visible = False
UserForm1.Show
End Sub


All times are GMT +1. The time now is 04:16 AM.

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