Msadiqrajani
Board Regular
- Joined
- Jan 17, 2009
- Messages
- 107
Hi,
I am beginner Mac scriptor and trying to convert my Excel application to Mac Excel 2008.
I am trying to unhide hidden rows but unable to do this.
I have tried these codes
First code does nothing neither provides any error.
But second one throws this error.
Second question is that I want to attach Mac Script with buttons on Excel.
I was unable to figure out how to do within excel so I googled and found this script.
I planed to attach my scripts to button on file open but I am surprised that this only works with 1 button.
Script will work with last button i attached script but for other buttons, Excel hangs up.
Thanks for reading my long details.
I am beginner Mac scriptor and trying to convert my Excel application to Mac Excel 2008.
I am trying to unhide hidden rows but unable to do this.
I have tried these codes
Code:
set hidden of format of range "1:5" to false
Set hidden of range "1:5" to true
But second one throws this error.
Code:
cant set hidden of range "1:5" to true
Second question is that I want to attach Mac Script with buttons on Excel.
I was unable to figure out how to do within excel so I googled and found this script.
Code:
tell application "Microsoft Excel"
set actionString to "run script \"Macintosh HD:Users:merickson:Desktop:Untitled 2.scpt\" as alias"
set shape on action of shape "Button 2" of active sheet to actionString
end tell
Script will work with last button i attached script but for other buttons, Excel hangs up.
Thanks for reading my long details.