spurs
Active Member
- Joined
- Oct 18, 2006
- Messages
- 479
- Office Version
- 2016
- 2013
- 2010
- 2007
- 2003 or older
- Platform
- Windows
Is it necessary to unprotect a worksheet containing a chart in order to have VBA code rescale the chart? I am trying to force a scale change using VBA code and I find that it only works if the chart is unprotected.
Is there a workaround without needing to unprotect and protect the sheet after every calculation
Is there a workaround without needing to unprotect and protect the sheet after every calculation