Home

Excel one drive VBA not working

Highlighted
AndyDDUK
New Contributor

Hi, I've created an Excel workbook with VBA. 

 

I've uploaded  this to One Drive and cannot now run the VBA. I've googled for an answer an am unclear on the next steps...can macros not be run within One Drive, or do they need to be made into eg trusted documents?...(and if so, how do i do this?)

 

(Note: as this workbook will contain a data connection to a partner site Zapier, who are creating the connection of us, say this workbook needs to live on the One Drive account.

 

Thanks

 

Many thanks Andy

4 Replies
Highlighted
Hi Andy! Try your actions with MS Flow instead auf your vba procedures and use a PowerApp Form. VBA is past. And another question: is it working as a normally saved file on your desktop? Greets, Eva
Hi Andy

Are you trying to run the VBA while opening the file in Excel Online? VBA won't run in Excel online.
Highlighted

Yes, am trying to do that. Thanks

Highlighted

Thanks, will look into that.

 

The VBA works fine on my laptop desktop (very quick)

 

 

Related Conversations
Userform/Command Button to Appear in New Worksheet
Mr_Buttons in Excel on
0 Replies
Version 2001 Excel 365 and no Dynamic Arrays
MilesWilliams in Excel on
5 Replies
$ symbol changes format of cells automatically
gbetar01 in Excel on
2 Replies
Excel table formatting best practices question
Jerry1385 in Excel on
2 Replies
If/Then Formula Not Drawing Across Sheets
Matt010614 in Excel on
2 Replies
FREQUENCY
enaugle in Excel on
3 Replies