Hi, I'm using a Forms Control Scroll bar in Excel 2010. I have 14 sheets in my active workbook. I want the user to click a button on the last sheet that increases the "max" property of the scroll bar by 1. How can I achieve this? I have only seen code that works on workbook_change(), not with a button click. Thank you for your help!!

---------- Post added at 04:32 PM ---------- Previous post was at 04:13 PM ----------

Anyone? I keep getting 'Specified Dimension is not valid for current chart type'