[mso] Re: Protected Excel Wookbook

It sounds like the calcualtion sheet is xlVeryHidden. To unhide it if this is 
the case, press Alt-F11 or select Tools >> Macro >> Visual Basic Editor. When 
the Visual Basic Editor (VBE) opens up, select View >> Project Explorer. In the 
Project Explorer panel, your workbook will be listed with all the sheets in it. 
Click on the calculation sheet, then press F4. Change the Visible property from 
xlVeryHidden to xlVisible. Save the workbook, then press Alt-Q to close the VBE 
and return to regular Excel.
 
Hope this helps,
 
Hutch
--- On Tue, 11/4/08, Jonathan Drawer <jdrawer07@xxxxxxxxx> wrote:

From: Jonathan Drawer <jdrawer07@xxxxxxxxx>
Subject: [mso] Protected Excel Wookbook
To: mso@xxxxxxxxxxxxx
Date: Tuesday, November 4, 2008, 7:51 PM

I have an Excel Workbook that performs some calculations based on data on an
Input Worksheet (or Tabsheet) and displays the results on some Output
Worksheets.  All of the calculations are performed on one Worksheet.  The
person that created the Workbook somehow has hidden the calculation Worksheet. 
That person is no longer employed by the company and I have been asked to make
some changes to the calculations.  However, I cannot determine how the
calculation Worksheet is hidden.  There is no selection in the Menu to
Unprotect anything, which I would expect to find as a choice on a protected
Workbook.  I select all of the tabsheets and there is no choice to unhide a
tabsheet, like I generally get when I hide one.

Something else that may be related is that I need to change the company logo on
all the Worksheets.  If  I click on the present logo image then I cannot
delete it.  If I try to drag the image into a new position then it just creates
a copy of the image in the new place.

Does anyone know how the Workbook might be protected and how to unprotect it so
I can make the changes needed?

Thank you in advance for any help.
Jonathan



      
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the
dropdown menu at the top.  This will allow you to unsubscribe your email address
or change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to share files with the group, you must join our Yahoo sister group.
 This group will not allow for posting of emails, but will allow you to join and
share problem files, templates, etc.: 
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE
SHARING ONLY.

If you are using Outlook and you see a lot of unnecessary code in your email
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************



      
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to share files with the group, you must join our Yahoo sister group. 
 This group will not allow for posting of emails, but will allow you to join 
and share problem files, templates, etc.:  
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE 
SHARING ONLY.

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

Other related posts: