PDA

View Full Version : Solved: Weird workbook on open



jmenche
09-18-2007, 11:58 AM
Howdy,

I opened a workbook and none of the sheets are maximized nor will it let you. I even tried code. Another strange thing is that you can't even move them by clicking and dragging. Are there any properties that I need to change??

Thanks

:beerchug:

jmenche
09-18-2007, 12:00 PM
another thing is...i cannot resize the sheets and the only way to close the file is under the File menu.

jmenche
09-21-2007, 05:43 AM
Nobody has any ideas?? :dunno

rory
09-21-2007, 05:57 AM
Just sounds like the workbook has been protected to me. Do you have the password?

jmenche
09-21-2007, 06:24 AM
This workbook is our time tracker here. There usually is protection but now it actually seems like it is off! I can edit every cell. I'll try and remove the passwords anyway.

rory
09-21-2007, 06:34 AM
I'm talking about Workbook protection, rather than Worksheet protection. Check under Tools-Protection-Unprotect Workbook; I think it has been protected for Windows as well as structure.

jmenche
09-21-2007, 06:48 AM
Thanks Rory. Breaking...er...removing all of the passwords fixed the issue.