I think Jan Karel Pieterse probably created the first example of using a worksheet to collect user input. jkp-ads.com/Articles/Excel-office-script-examples.asp#Prompting_for_user_input I've just taken it to the next step by using Shapes and Ranges, plus I've used buttons to control them. In terms of the code and methods, I've created all of that myself.
how did you make it so the shapes were not selectable/moveable. Whenever i click on a shape it shows a line with dots around it to allow for resizing and moving. Is there a way to prevent that?
Great job Mark!
Thanks Ben 😀
thank you for this neat demonstration Did you find this all by yourself?
I think Jan Karel Pieterse probably created the first example of using a worksheet to collect user input.
jkp-ads.com/Articles/Excel-office-script-examples.asp#Prompting_for_user_input
I've just taken it to the next step by using Shapes and Ranges, plus I've used buttons to control them. In terms of the code and methods, I've created all of that myself.
how did you make it so the shapes were not selectable/moveable. Whenever i click on a shape it shows a line with dots around it to allow for resizing and moving. Is there a way to prevent that?
Is it possible to upload the file to the platform? I have some errors and I don't see the way to fix them. Thank you.😩
I've added the download files to the blog post. If it's not working because I've done something wrong, just let me know.
lovely jubbly
With introduction of checkboxes, I suspect worksheet based will be the future.