Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default protected workbook for windows

I wish to apply workbook protection and protect for windows. Is there any way
of instructing the workbook to open to a specific size (eg full-screen). I
cant quite see the point of protecting for windows if Excel simply decides
the window size!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default protected workbook for windows

Before protecting the workbook, un-maximize it and resize to full size.

Then protect with windows and structure checked.

Save and close.

The workbook will open to the size you saved with.


Gord Dibben MS Excel MVP

On Mon, 13 Nov 2006 07:27:01 -0800, Hendon
wrote:

I wish to apply workbook protection and protect for windows. Is there any way
of instructing the workbook to open to a specific size (eg full-screen). I
cant quite see the point of protecting for windows if Excel simply decides
the window size!


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) [email protected] Excel Worksheet Functions 0 September 5th 06 03:44 PM
Opening Protected EXCEL worksheets to update linked data doctorjones_md New Users to Excel 9 August 7th 06 10:51 AM
Excel 2000 how to use filters in protected workbook Jimmar New Users to Excel 1 May 26th 05 05:14 PM
Unprotect Workbook Kent Excel Discussion (Misc queries) 1 February 4th 05 01:07 AM
How can I save an editable copy of a protected excel workbook? randyice Excel Discussion (Misc queries) 1 December 23rd 04 09:01 PM


All times are GMT +1. The time now is 02:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"