Toggling AutoRepublish

Hello,

I have a large workbook with multiple sheets which has the "AutoRepublish when saved" option to create about 30 HTML files on a network drive each time the workbook is saved.

This is fine for desktops that are always connected, but for our tablets and when working offline, I'm looking for some way in VBA to temporarily toggle the AutoRepublish feature for all sheets before saving to avoid a load of error messages saying the path isn't available.

I have an existing Workbook_BeforeSave event that I can use, so I can offer the user a yes/no MsgBox to ask whether to publish or not.

I've tried a quick Google, but haven't come up with anything - unless I'm searching for the wrong thing!

Any help appreciated.

Please Login or Register  to view this content.

Turn on your macro recorder (developer tab) and manually turn off / on auto republishing. Check the new Module that's appeared in the VBA editor to see the result. It'll look very much like the above.