Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 458
  • Last Modified:

Can we use Macro's for excel 2007 on shared worksheets.

Hi,
I have excel sheets when shared i am not able to use the macro.Is there anything i need to do Any workaround.
Even when i have a Macro in Outlook and Ctl+Alt+Del and then login the Module opens up every time i lock and unlock the computer.

Regards
SHarath
0
bsharath
Asked:
bsharath
  • 5
  • 3
  • 2
2 Solutions
 
patrickabCommented:
SHarath,

Excel does not handle 'Shared' workbooks reliably. They are often corrupted at random and apparently without cause. Clearly there is a cause but it has not yet been isolated and fixed by MS. There is nothing you can do to avoid shared workbooks corrupting. The ONLY thing that can be done is to make them single user.

To help you with the single user file system try adopting this approach instead. It does work rather well so it's worth doing. First make the file(s) single user. Second edit everyone's user profile in Excel - Tools/Options/General/UserName and in there put the person's name and telephone extension number. Then whenever you attempt to open a file that someone else is using, a dialogue box will pop-up telling you who is the current user - and it tells you their telephone extension number! The new user can opt to either call the current user or open the file as read-only.

For Office 2007:  Office Button > Excel Options >Popular tab >User name

Patrick
0
 
bsharathAuthor Commented:
Patrick.
IS there a way to run Macro's on a shared worksheet.?
0
 
patrickabCommented:
bsharath,

Yes there is. However to provide that information would be totally contrary to my recommendations of not 'sharing' workbooks.

Patrick
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
bsharathAuthor Commented:
But there is no other way at this point for me.We need to finish a bit asset detail where 3 persons have to work on the file.
0
 
patrickabCommented:
I suggest you get them to work on the file at different times - all as single users.
0
 
James ElliottManaging DirectorCommented:
I too agree with Patrick in respect of shared workbooks, but I'm prepared to try and help given that your problem sounds fairly immediate.

What error message do you get? Running simple macros should work. Shared workbooks however do have some disabled features that can only be used if opened exclusively. Merging cells, conditional formatting, charts, sheet additions/deletions, subtotals, validation  to name but a few.

If your macro attempts to do any of these things, then there is no workaround, other than to use the solution suggested by Patrick.

Jell

0
 
bsharathAuthor Commented:
My question is if the worksheet is shared can we se macros.
In my machine i am not able to use macro's on shared sheets.
0
 
patrickabCommented:
Use the file as a single user file and then each user will have access to the macros in the file. Sorry, but that is my best recommendation.
0
 
James ElliottManaging DirectorCommented:
No, the code behind macro's cannot easily be viewed when the workbook is shared. It is possible however to run macros that do not infringe my afformentioned contraints.

The 'best' solution however is the one that Patrick has already proposed.
0
 
patrickabCommented:
SHarath - Thanks for the grade and points - Patrick
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 5
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now