Fixed column width

[Terriz]

Hi,

I'm trying to create a vb to get all columns on my sheet to have a fixed width.
If I run my sub all columns go back to the set width. But I want the width to reset when the width is changed.

Please Login or Register  to view this content.

[Andy Pope]

I don't belive there is an event raised by resizing a columns width. So you will not be able to capture at the time of change.

You could add event code to check every time selection changes or worksheet is deactivated or just before saving.

Maybe better to use sheet protection

[Terriz]

Ok... well maybe sheet protection is the way to go. Thank for the quick reply.