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
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
another thing is...i cannot resize the sheets and the only way to close the file is under the File menu.
Nobody has any ideas??
Just sounds like the workbook has been protected to me. Do you have the password?
Regards,
Rory
Microsoft MVP - Excel
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.
Regards,
Rory
Microsoft MVP - Excel
Thanks Rory. Breaking...er...removing all of the passwords fixed the issue.