workbook not acting like normal window

madam_lash · Apr 19th, 2002, 06:47 AM

I have created a workbook called "Participants" with 5 sheets. Yesterday it did something strange and now it appears on screen without the minimize/maximize/close icons in the top right corner and does not show the sheet tabs. I can't resize the window or move it. I can click on the sheet and move around using the arrow keys. I've tried everything - checked all menus and options. When I open other files, they act like a normal window. It feels like I've done something to "Participants" accidentally and put it into some kind of different mode. How did I do it? I've been using Excel for years and I've never seen this before. How can I fix it? It seems to me the only way out of this is to copy and paste all the data into a new workbook. And then reformat it all. Surely not??
Help!!

madam_lash · Apr 19th, 2002, 06:59 AM

Hooray! I just worked it out.
What a dummy - it was the old protection trick...
Thanks for this fantastic service.
Kind regards
Julie

Chris Davison · Apr 19th, 2002, 01:08 PM

Glad I was able to help

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 19th, 2002, 06:47 AM	#1
madam_lash New Member Join Date: Apr 2002 Location: Julie Posts: 2	I have created a workbook called "Participants" with 5 sheets. Yesterday it did something strange and now it appears on screen without the minimize/maximize/close icons in the top right corner and does not show the sheet tabs. I can't resize the window or move it. I can click on the sheet and move around using the arrow keys. I've tried everything - checked all menus and options. When I open other files, they act like a normal window. It feels like I've done something to "Participants" accidentally and put it into some kind of different mode. How did I do it? I've been using Excel for years and I've never seen this before. How can I fix it? It seems to me the only way out of this is to copy and paste all the data into a new workbook. And then reformat it all. Surely not?? Help!!

Apr 19th, 2002, 06:59 AM	#2
madam_lash New Member Join Date: Apr 2002 Location: Julie Posts: 2	Hooray! I just worked it out. What a dummy - it was the old protection trick... Thanks for this fantastic service. Kind regards Julie

Apr 19th, 2002, 01:08 PM	#3
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	Glad I was able to help