Leigh Metcalfe
New Member
Can you help me, im looking for it to only point to a certain location on our server to include sub folders and a pick the tab called Deliveries, this is so the end user cant see what deliveries any other customer has.
I then wish it to save the work book as todays date.
also I have worked out how to get it to rename the sheet according to cell A1, but sometimes the cell reference is either to long or has a - in the title.
is there is a way i can remove all text i.e Metcalfe - Isle Of Dogs, i want the cell to only have Isle Of Dogs, all text previous to the - would be deleted.
i have copied the coding from http://forum.chandoo.org/threads/vb...rksheet-in-all-macro-enabled-workbooks.21826/
I then wish it to save the work book as todays date.
also I have worked out how to get it to rename the sheet according to cell A1, but sometimes the cell reference is either to long or has a - in the title.
is there is a way i can remove all text i.e Metcalfe - Isle Of Dogs, i want the cell to only have Isle Of Dogs, all text previous to the - would be deleted.
i have copied the coding from http://forum.chandoo.org/threads/vb...rksheet-in-all-macro-enabled-workbooks.21826/