Find worksheet
 

I have a workbook that is constantly having sheets added. I would like to
run a macro where clicking on a button goes to the sheet before "last sheet".
Is this possible?

Thanks in advance

Find worksheet
 

make a button and in the code for it put

Sheets(Sheets.Count - 1).Select

--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"LantzK" wrote:

I have a workbook that is constantly having sheets added. I would like to
run a macro where clicking on a button goes to the sheet before "last sheet".
Is this possible?

Thanks in advance