'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.:confused:


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

'Save current worksheet'; 'Open next worksheet' - two command buttons
 

Oops - forgot to upload the file in the correct format (i.e. zip). Now
rectified.

/Rog.


+-------------------------------------------------------------------+
|Filename: customer_survey_short_070406.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4600 |
+-------------------------------------------------------------------+

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