Re: [libreoffice-users] Macro/button that allows sorting and hiding/unhiding on protected sheet?

Anyone?


On 1/16/2017, 11:12:21 AM, Tanstaafl <tanstaafl@libertytrek.org> wrote:
> Hello all,
>
> I am not a programmer, but I'm trying to add a few buttons to a
> worksheet that will allow the boss to do a few things on a protected
> sheet that you normally can't do without unprotecting it.
>
> Is it possible to create a macro that can, for example, hide/unhide (so
> it would be a toggle button) a group of columns by simply clicking on
> it, without the user first having to unprotect the worksheet? Would this
> require me to actually include the unprotect/re-protect steps into the
> macro? Which would also mean embedding the password?
>
> Same question for sorting on certain columns, although the sort would be
> just one way (sort order should always be descending).
>
> Thanks!
>
> Charles


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted