G
Guest
Can you hide some worksheets within a workbook from some users.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
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
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
P
peter
J
Jack in the UK
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 thi
to unhide to show the once hidden sheet
VBA is better thou:
Jac
-
Jack in the U
Sheet and clik on hide.
This is the most basic and simplist way to hide a sheet, reverse thi
to unhide to show the once hidden sheet
VBA is better thou:
Jac
-
Jack in the U
J