Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protect a worksheet but allow column resize
Hi,
I am generating a worksheet and enabling protection and I notice that it is impossible to resize the columns. Is there any way to protect a worksheet, but allow the user to resize the columns? I am using Excel 2000. Phil |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protect a worksheet but allow column resize
In Excel 2000,
Not really. You could write a macro that provides an interface to the user and then the code resizes the column. You could do this by having your code unprotect the sheet, size the column, protect the sheet, or using the UserInterfaceOnly:=True property of the protection method (only available in code). -- Regards, Tom Ogilvy "Phil Jollans" wrote in message ... Hi, I am generating a worksheet and enabling protection and I notice that it is impossible to resize the columns. Is there any way to protect a worksheet, but allow the user to resize the columns? I am using Excel 2000. Phil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I insert and resize a column on only one worksheet page? | Excel Discussion (Misc queries) | |||
hide, unhide column or row after protect worksheet | Excel Discussion (Misc queries) | |||
how do I protect a column on a worksheet | Excel Worksheet Functions | |||
protect worksheet but allow copy column | Excel Worksheet Functions | |||
hide a column in a worksheet and password protect | Excel Discussion (Misc queries) |