@OldJack
The error message âAn exception ocurredâŚâ points to line 7543 in the source file cellsuno.cxx.
It might be related to unprotecting the sheet.
Your macro works for me. So does the keyboard combo Ctrl+Shift+E.
Please check the password for the âPlay_Scheduleâ spreadsheet.
I get the error message âAn exception ocurredâŚâ if the password for the sheet in question does not equal âeditâ.
Upon further investigation I was returned the following error message:
âA Scripting Framework error occurred while running the Basic script vnd.sun.star.script:Standard.Play_Schedule.Sort_Game1_ByRink?language=Basic&location=documentâ.
Message: The following Basic script could not be found:
library: âStandardâ
module: âPlay_Scheduleâ
method: âSort_Game1_ByRinkâ
location: âdocumentâ
at C:/cygwin64/home/buildslave/source/libo-core/scripting/source/basprov/basprov.cxx:356
The problem with this message is that none of my macros are in the âStandardâ library. Thay are in a library name âBowlsâ. But this message shows up on 7 macros related to Button Controls on the Play_Schedule.
Unfortuately I cannot edit the Button Controls macro assignment because for some reason the password for the Play_Schedule is returned as wrong. But it has never been anything than what it is. It couldnât be accidentally changed because it is set by a macro. Iâve double checked all the macros that set the password and they are all the same.
Any ideas?
Thanks,
OldJack
Please donât ask unrelated questions, just because you were the original author of something called âFull screen mode in Calcâ. Or is âwhen I press a quick key combination assigned to a macro I get the followingâ related somehow, and others asking for a solution to that would easily find this continuing discussion, and benefit from a possible solution?