View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
englishmustard
 
Posts: n/a
Default 'Save current worksheet'; 'Open next worksheet' - two command buttons


I'm 'designing' (if a beginner can aspire to such things) a worksheet to
facilitate data input for a customer satisfaction survey.

I'd like to have two command buttons on the worksheet: one to save the
current worksheet and the other to close the current worksheet and open
the next (worksheets will be in alphanumerical order, e.g. C1, C2).

Is it possible to do this with VBA?

I've uploaded the file.

Many thanks,

/Roger.


--
englishmustard
------------------------------------------------------------------------
englishmustard's Profile: http://www.excelforum.com/member.php...o&userid=31804
View this thread: http://www.excelforum.com/showthread...hreadid=530875