View Single Post
 
Old 10-28-2017, 06:47 AM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default

Quote:
The only thing that I couldn't see working was if the User of a particular device changes is updated on the Master sheet. Is it possible to rerun the macro on demand to get it to update the changed user(s) on their applicable worksheet(s)?
Are you sure about that ?

Right click the "CFD Basic Info" tab and select View Code.
Insert the word STOP as the first line in the Worksheet_Change sub.
Go back to the "CFD Basic Info" sheet and click a hyperlink to view that sheet.
Note the User number.
Go back to the "CFD Basic Info" sheet and change the User for that hyperlink.
The code will stop and display itself with the STOP line highlighted.
Use the F8 key to step through the code one line at a time and see what happens.
When the sub finishes, check that hyperlinked sheet again for the User.

Before removing the STOP instruction, try inserting a line for another Ser No.
(do this near the top of the Ser No. list so you're not looping too often while doing things manually)
and use F8 again to see what happens and where the code goes.

Hope this helps to explain and show what's going on.
Reply With Quote