A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Hidden worksheets displaying on opening



 
 
Thread Tools Display Modes
  #1  
Old October 7th, 2003, 03:52 PM
randula
external usenet poster
 
Posts: n/a
Default Hidden worksheets displaying on opening

I have a problem that I haven't seen before. I have a
workbook that I update and distribute daily. This
workbook contains hidden worksheets that I do not want to
be displayed when I distribute, so I keep them hidden when
I save the file. This morning, upon opening the file, all
of my hidden sheets were displayed. I hid the sheets I
wanted hidden and saved the file and closed it. When I re-
opened the workbook, all of the hidden worksheets were
displayed again. I went to Outlook and pulled up some of
the workbooks I had e-mailed over the past several days.
I knew that those files had the worksheets hidden.
However, when I opened them today, all of the hidden
sheets were being displayed. Have I accidently changed a
setting that I am not aware of that is making this
happen? I have looked at all of the options and can't
find anything.

Thanks
  #2  
Old October 7th, 2003, 04:49 PM
Danny
external usenet poster
 
Posts: n/a
Default Hidden worksheets displaying on opening

It sounds like you have not protected the WORKBOOK.

-----Original Message-----
I have a problem that I haven't seen before. I have a
workbook that I update and distribute daily. This
workbook contains hidden worksheets that I do not want to
be displayed when I distribute, so I keep them hidden

when
I save the file. This morning, upon opening the file,

all
of my hidden sheets were displayed. I hid the sheets I
wanted hidden and saved the file and closed it. When I

re-
opened the workbook, all of the hidden worksheets were
displayed again. I went to Outlook and pulled up some of
the workbooks I had e-mailed over the past several days.
I knew that those files had the worksheets hidden.
However, when I opened them today, all of the hidden
sheets were being displayed. Have I accidently changed a
setting that I am not aware of that is making this
happen? I have looked at all of the options and can't
find anything.

Thanks
.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:40 AM.


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