Hi
I have a spin up and spin down button to add and decrease rows on spreadsheet but on close I want it to return to maximum number of rows.
Thanks in advance
Hi
I have a spin up and spin down button to add and decrease rows on spreadsheet but on close I want it to return to maximum number of rows.
Thanks in advance
You shall probably have some code for Before_Close event, but exact implementation depends on mechanism used for spinup/doen button action, so attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Best Regards,
Kaper
he arrows at the top increase and reduce amount of rows used I want it to reset to the maximum no of rows on close or clear
After brief look on the file, I think the appropriate place will be Workbook_Open event handler (in ThisWorkbook code):
![]()
Private Sub Workbook_Open() On Error GoTo errhandler: Rows("18:92").Hidden = False Exit Sub errhandler: MsgBox "There appears to be an error in Workbook_Open procedure. Please contact your administrator", vbCritical End Sub
Thank you very much for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks