ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   A work problem (https://www.excelbanter.com/excel-programming/360464-work-problem.html)

bluhevn

A work problem
 
We had a lady leave work and she had some macros set up in Excel. What
they are trying to do here is when some one different signs on they
want the same Excel macros to work for that person too. How do I go
about doing that or is that not possible.


Tom Ogilvy

A work problem
 
My guess is that the macros are in her personal.xls.

Use the file search capability to find all the files named personal.xls

You should then be able to identify which one was hers based on where it is
located.

You can rename that file and then put it in a place where others can open
it, then they can use the macros. Or you can transfer the macro's to their
personal.xls.

--
Regards,
Tom Ogilvy


"bluhevn" wrote:

We had a lady leave work and she had some macros set up in Excel. What
they are trying to do here is when some one different signs on they
want the same Excel macros to work for that person too. How do I go
about doing that or is that not possible.



bluhevn

A work problem
 
Thanks Tom I will give it a try and let you know the out come.


bluhevn

A work problem
 
Thanks you Tom Ogilvy that worked and everyone is happy.



All times are GMT +1. The time now is 06:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com