#1   Report Post  
Jo Davis
 
Posts: n/a
Default Hiding Worksheets

Can you hide some worksheets within a workbook from some users.
  #2   Report Post  
 
Posts: n/a
Default

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.
.

  #3   Report Post  
peter
 
Posts: n/a
Default

Hi,
Not without a macro. Otherwise format|sheet|hide.
peter

-----Original Message-----
Can you hide some worksheets within a workbook from some

users.
.

  #4   Report Post  
Jack in the UK
 
Posts: n/a
Default


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



  #5   Report Post  
Jack in the UK
 
Posts: n/a
Default


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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Number of worksheets Mark Excel Discussion (Misc queries) 1 January 18th 05 11:05 AM
HELP! How do you--> Lock a set of rows but also link worksheets to FRUSTRATED Excel Discussion (Misc queries) 6 December 29th 04 11:05 PM
data entry on multiple worksheets diosdias Excel Discussion (Misc queries) 1 December 7th 04 06:33 PM
Conditional hiding of worksheets KG Excel Discussion (Misc queries) 0 December 2nd 04 06:29 PM
Assigning Cells in worksheets to other data in other worksheets. David McRitchie Excel Discussion (Misc queries) 0 November 27th 04 07:15 PM


All times are GMT +1. The time now is 12:44 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"