Protect a worksheet but allow column resize

  • Thread starter Thread starter Phil Jollans
  • Start date Start date
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
 
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

Columns resize event 1
resize question 2
VB protect sheet but allow certain options 5
Allowing Chart creation in protected worksheets sheets using VB co 4
Worksheet change code to colour in rows in a database 7
Column resize event 1
How can I attach a combobox to a cell and have it resize if the column width is alterd 1
AutoFit Visible Rows 3

Back
Top