Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a simple zoom-to-fit macro that works fine when run on the desktop and it has been working fine on the server.
However, in the last day it seems to have stopped working on the server. I've checked that 'allow macro execution on server' and 'allow unsafe macro execution' are ticked on the QMC.
The only thing that I can remember doing of any significance is restarting the QMS, QMC and QS services
Sample macro that runs from a button is here:
Sub mcrZoom
set mysheet=ActiveDocument.ActiveSheet
set sp=mysheet.GetProperties
sp.ZoomFactor = 1.5
mysheet.SetProperties sp
End sub
Very grateful for any suggestions!
Thanks.
Thanks - but I've tried that, and it doesn't seem to help.
I'm not sure what has fixed it, but I've unchecked 'enable push from server' and 'macro override security' and re-opened internet explorer and it seems to work. Not sure exactly why this should have made any difference.
Will update this thread if I learn any more details.