2003/2007 Compatibility Issue - Hidden Sheets

N

NickH

I have a workbook created in Excel 2003, with a number of hidden
sheets. I need this workbook to also be useable in Excel 2007.

Neither the workbook nor the hidden sheets are protected but I can
find no way to make the hidden sheets visible in 2007.

Before someone replies with Home -> Format -> Hide & Unhide -> Unhide
Sheet... I should point out that this menu option is greyed out.

If I try to set the Visible property in the VBE to -1 - xlSheetVisible
I get the error msg: "Unable to set the Visible property of the
Worksheet class". Naturally I get the same msg if I try changing the
setting via VBA.

Is this a known problem and is there a work-around?
 
D

Dave Peterson

It sounds like your workbook's structure is protected.

Check on the Review tab|Changes group (in xl2007)

or
tools|protection|Unprotect workbook (in xl2003 menus)
 
P

Peter T

Everything you describe strongly suggests the Workbook structure is
protected, as Dave suggested. Might be worth a second look!

Regards,
Peter T
 
N

Nick H

Doh! It IS protected!

My apologies Dave. But from the Excel 2007 UI its not obvious - On the
Review tab/ribbon in the Changes section there's an icon staring at me
saying 'Protect Workbook'. I figured, logically, if the workbook was
protected it should say 'Unprotect Workbook'. It was only when I
double-checked in the Tools menu on a machine running Excel 2003 that
I realised it was actually protected.

Sorry for wasting your time.

- Nick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top