Hiding Worksheets
Can you hide some worksheets within a workbook from some users.
|
yes
but only if they open the file from the machine they are logon to. in the workbook open event: Sub macHideSheets() If CreateObject("Wscript.Network").UserName = "name" Then Worksheets("Sheet1").Visible = xlVeryHidden End If End Sub you may need to add a few ORs, 1 for each user you want to hide sheets from and a line for each sheet you wish to hide. note: using the xlveryhidden command will not let you unhide the sheet through the menus so in the workbook before close event: Sub macUnHideSheets() Worksheets("Sheet1").Visible = true End Sub -----Original Message----- Can you hide some worksheets within a workbook from some users. . |
Hi,
Not without a macro. Otherwise format|sheet|hide. peter -----Original Message----- Can you hide some worksheets within a workbook from some users. . |
Sure select the tab of the worksheet you wish to hide, click Format | Sheet and clik on hide. This is the most basic and simplist way to hide a sheet, reverse this to unhide to show the once hidden sheet VBA is better thou: Jack -- Jack in the UK ------------------------------------------------------------------------ Posted via http://www.mcse.ms ------------------------------------------------------------------------ View this thread: http://www.mcse.ms/message1341880.html |
Please have a look at a post i made earlier http://www.mcse.ms/message1343219.html Jack -- Jack in the UK ------------------------------------------------------------------------ Posted via http://www.mcse.ms ------------------------------------------------------------------------ View this thread: http://www.mcse.ms/message1343227.html |
All times are GMT +1. The time now is 12:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com