Try the attached file. You will notice that I removed all the macros in each individual worksheet code module and instead placed one macro in the code module for ThisWorkbook which will apply to all worksheets except "ECP Form". Please note that this macro is based on the current sheet name and sheet codename structure in the Form.xlsm workbook. If this changes in any way, the macro very likely won't work as expected.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Yet again you've nailed it. I had to make a few minor changes to get it perfect but wouldn't have been able to work it out without your assistance. Tahnks again Mumps1.
My pleasure.
Sorry Mumps1 I'm back again.
Now I'm not sure this is even possible and I'll try my best to explain.
With the existing documents you have resolved for me I need a button that opens a Visio document. That's easy enough as I have done this but I need it to be more intuative.
As you can see when I press the "Launch Site Survey Form" button it unhides a sheet and there are 65 hidden in total. Once the Site name field is filled in it renames the Sheet to whatever the name of the site is. Simple so far.
What I would like is a button on each of these sheets that when pressed opens a visio document with the same name as the sheet which contains a floor plan of that particular site. So for example if I named the sheet Worcester, when the button is pressed Worcester.vsd opens. If I name the next sheet London, london.vsd opens.
Is this at all possible? See example documents and you can see what I have tested so far. (unable to upload .vsd file so have uploaded a PDF as it will be the same priciple just a different application)
Try the attached file.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks