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

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