We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Auto size column width on protected worksheet [closed]

asked 2012-05-24 18:17:37 +0200

anonymous user


updated 2013-01-27 21:06:24 +0200

qubit gravatar image

I've set up a Calc template with several password protected sheets. Is there a way to (preferably automatically) shrink/grow the column width dependent on the cell contents without turning off the password protection and resizing the columns after the data is entered?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-27 01:45:45.445825


Hi @Anonymous -- Have you found an answer for your question? Still looking for an answer?


qubit gravatar imagequbit ( 2013-03-12 02:42:25 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2013-03-17 05:56:30 +0200

razon_22 gravatar image

updated 2013-03-17 05:58:47 +0200

You can create a macro to resize the columns then assign the macro to a certain event like opening or closing a document. Macros are an experimental feature currently and it has to be enabled from Tools > Options. You will also need a Java runtime installed. Once the macro is created, go to Tools > Customize, click the Events tab and choose the event to associate it with. One of the options is to run the macro after the modified status is changed. If you choose that event, it will run it every time a cell is changed. Let us know if this works for you.

edit flag offensive delete link more

Question Tools


Asked: 2012-05-24 18:17:37 +0200

Seen: 1,146 times

Last updated: Mar 17 '13