Protect a worksheet but allow column resize

P

Phil Jollans

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
 
T

Tom Ogilvy

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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Resize a row but copy but skip columns I don't want to copy 6
Protect a worksheet but allow cell editing 3
Resize a Table using VBA 9
Lookup Formula Problem 2
Named cells in an array to a column and to a row 3
Resize Range for Column 3
Protect a single worksheet? 6
merge worksheets 3

Top