Send Workbook Limiting Sheet View

[Blowfish]

Hey guys.

I am new into this VBA Macro thingy, and I would appreciate some help to complete my Excel document. No asking to do it for me , hence assist me if possible as I intend to learn it too.

So, I did create a Service request form (excel xlsm) simple document, where the applicant fill in the details in SHEET1 and it is copied all the details to SHEET2 using a simple link, which Sheet2 is send out as receipt.

On Sheet1 there is a macro button to send Sheet2 only as email attachment, which Sheet2 has 2 other macros. However, the fact that all the data is originate (linked) from Sheet1 it requires to Break the links once the document sent is open, but breaking the link VBA code somehow it unlink the macro buttons which is not ideal.

Therefore, how can I do to send the whole Workbook, and permanently show ONLY a specific worksheet “Sheet2”, so the people can’t see other data within the whole document, by doing so I assume it wouldn’t need to break any link. Does it make sense.

Looking forward to hearing from you.

All the best

 

[ScottUlmer]

So what you need to do is have it run a macro on start-up that is Sheet1.Visible = False. Then whenever you call a macro that needs Sheet1 do Sheet2.Visible = True, once the macro has ran have it end with Sheet2.Visible = False. Sorry for the late reply, I hope this still helps!