Running a Macro from within Onedrive
Running a Macro from within Onedrive
(OP)
I have Excel spreadsheets that I would like to allow access to from my website. Using Onedrive, I can embed the HTML code for the spreadsheet in the website and allow access to anyone. This does not work with the macro's that I have in the spreadsheet because I use a graphic or button to run the macro. How can I run the macro without a graphic or button? For instance, is there a command that will run the macro when a cell has changed or when a recalculation occurs?





RE: Running a Macro from within Onedrive
You can write VBA code to run a macro when certain events occur, or you can access a list of all macros by pressing Alt-F8, but neither will won't work from a browser.
As far as I know your only option is to re-write the macro in JavaScript.
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Running a Macro from within Onedrive
Thanks, I'm going to try the following:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$E$3" Then
Call My Macro
End If
End Sub
This works in Excel 365 so I'll try it via the website.
RE: Running a Macro from within Onedrive
RE: Running a Macro from within Onedrive
If I do come across a way forward (with a manageable learning curve) I'll post here (but I wouldn't hold your breath).
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/