Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I have a request to freeze columns (their width and initial position) in most of the tables in my application.
I've tried to use "Read Only" option, but first of all it is not providing me a required result (the columns are still flexible) and second of all, some of y table still need to receive an input from the user.
I would appreciate any suggestion about how to handle this request.
Vlad,
Right-click on the sheet, select Sheet Properties. Go to the Security tab. Uncheck "Move/Size Sheet Object," check "Apply to All Sheets," and press OK. That should take care of the column widths.
Next, in the chart go to the Presentation tab and uncheck "Allow Drag and Drop." That should take care of column positions.
Cheers,
Vlad,
Right-click on the sheet, select Sheet Properties. Go to the Security tab. Uncheck "Move/Size Sheet Object," check "Apply to All Sheets," and press OK. That should take care of the column widths.
Next, in the chart go to the Presentation tab and uncheck "Allow Drag and Drop." That should take care of column positions.
Cheers,
It was quick! I should probably just call you directly
Thanks, it works exactly as I needed.
Regards,
This way we both get some forum points out of it too 🙂