Thank you Rob will keep this in mind. My problem has been
sorted thank you very much.

-----Original Message-----
Alistair, it is very likely that you will not get a
response to your
request. Typically one posts a specific problem for
solution versus a
request for a complete macro.

Robert Flanagan
Macro Systems
Delaware, U.S. 302-234-9857
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros
for Excel



"alistair" wrote in
message
...
Hi

I am sending a spread sheet out to branchs I need them
to
complete a sheet (common info) before they do anything
else on the workbook. I am looking for a macro or code
for
VBA which who check (common info) see if the cells are
complete if not bring up a error screen informing the
user
to complete the form and then take them straight to the
(common info) sheet. and if possible let them go to the
tab which they want to go to.




.