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
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.
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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.