Macros Disabled In A Shared Workbook

Jan 17, 2007

My macros don't work when the workbook is shared. They are not stored in my personal workbook and so are available to all users. What's going on?

View 3 Replies


ADVERTISEMENT

Automatically Close Workbook If Macros Are Disabled

Apr 16, 2008

If a user disables macros when opening a file, is there a way to have the excel file automatically close?

View 9 Replies View Related

Excel 2010 :: Macros No Longer Work When Workbook Shared

Aug 22, 2012

Using Excel 2010.

I've created a spreadsheet at work that has two summary tabs which contain hyperlinks to around 30 separate sheet tabs.

On each sheet tab there is a list of unique values in column A (and other information relating to each value in columns B to D which are repeated for more than one unique value). In column E, users enter a test script name against each unique value they wish to 'reserve', and the macro picks out the unique test script names and via the COUNTIF formula counts the frequency of each test script name for each of the different values in column B.

My problem is that the macro seems to work fine if the workbook is not shared, but errors if the workbook is saved as shared. The error is 'Run time error 1004 - Unable to select the MergeCells property of the Range class'.

Here is the macro code:

Sub Get_Policies_Per_Script(updCol As Long, ShtName As String)
Dim rowctr As Long
Dim tgtrow As Long

Const ppsformula As String = "=COUNTIFS($A$3:$A$65000,I$24,$E$3:$E$65000,$G"

If updCol = 5 Then 'test name column has been modified

[Code] ..........

View 9 Replies View Related

Warning When Macros Are Disabled

Jun 22, 2007

How can I write a "warning" in the form of a message box that will appear if the user does not enable macros?

Also, can I have one of the buttons on this message box turn on macros?

View 9 Replies View Related

Security Warning (Macros Have Been Disabled)

Apr 28, 2008

I was playing around with Macros on an excel file. I created a few and ran them. In the end, I didn't like the way they ran, so I deleted them all. However since I ran them in the excel file, every time I open the file it gives me a warning saying
"Macros have been disabled."

Is there any way to remove the possible Macros ties/links from my file? I know I can disable the warning, but if I just want to remove the Macros ties to my file.

View 10 Replies View Related

Edit Macro When Macros Disabled

Oct 23, 2006

I accidently put the Application.Quit command in the wrong place. Now Excel closes immediately when the macro executes. I can get into Excel if I disable the macro, but then it won't let me edit the macro. Is there a way to edit my macro without executing it?

View 7 Replies View Related

Prohibiting File From Opening If Macros Are Disabled?

Feb 23, 2003

I have a file that contains Macros that I want to share with others. The only problem I have is that users have the right to enable or disable macros. If they disable the macro - some of the security functions could be lost.

Is there a way to create a macro that will not allow the file to be opened if they choose to Disable the Macros.

View 9 Replies View Related

If Macro Is Disabled: Place A Message On The Sheet Saying This Will Only Work With Macros Enabled

Aug 17, 2006

When you enable macros the sheets 2, 3, 4 ect are visible but if you disable macros, you only see sheet 1 and and you can place a message on the sheet saying this will only work with macros enabled.

View 2 Replies View Related

Running Macros In A Shared Workb

Dec 14, 2002

Whenever I share a workbook, I experience problems running macros that are problem-free otherwise. Iíve read the help menu about restrictions of using shared workbooks, but I did not run across anything that might explain this behavior. Iíve experimented with a few spreadsheets and I run across this problem in all cases. Can anyone help with an explanation or past experience? Iím assuming that by sharing a workbook, the workbook is automatically protected for both windows and structure. If this is what is causing the problem, is there code I can use to still allow my macros to run trouble free in a shared workbook?

View 9 Replies View Related

Track Changes Disabled On Network Workbook

Jul 31, 2006

when i put a file across a network, it should be shared among all the users, but it appears as read only file and the option of track changes in the tools function is disabled. However, when i open an excel file in a stand alone pc, and use the track changes option, i get the file as (shared) as the header. what is the significane or meaning of this word "shared" in a stand alone pc?

View 2 Replies View Related

Delete Sheets And Create New Workbook In Shared Workbook

Jun 2, 2014

I wrote a code in unshared workbook and it works fine. But when i make it shared i get Run-time error '1004' Delete method of worksheet class failed.

The Deleting of worksheet only occurs once (when the new wb is created) so is there i can unshare and share it back when the process is complete?

View 3 Replies View Related

Disabled "Delete" For One Workbook Turned Out To Be Applied To Every Workbook...

Jul 13, 2009

I wanted to disable the function "Delete" when right-clicking on worksheets.

I copy paste the following VBA code in every sheet code :

View 10 Replies View Related

Changes To Shared Workbook

May 6, 2006

I have an Excel workbook which is networked throughout our business. Its been in daily use for years with no problems. Every month I add a new sheet and to do that I untick the "allow changes by more than one user...etc". However this month the tick is greyed out and wont let me clear it. The pc's run windows XP professional with Excel 2003.

View 2 Replies View Related

Remove [Shared] Workbook

Jul 22, 2009

I have a workbook that is no longer being shared. I tried clicking on Tools > Shared Workbook. BUT i keep getting a message saying "The file C:CCTPAccountsSummary1.XLS cannot be found". Is there any way to kill this Shared workbook so I am free to modify everything?

View 2 Replies View Related

Combobox In Shared Workbook

Dec 16, 2008

Please follow the link ..... This works perfectly for me.. But it doesnt seem to work in shared workbooks.

View 14 Replies View Related

Speed Up Shared Workbook?

Aug 19, 2013

how to speed up a shared excel worksheet?

View 4 Replies View Related

Shared Workbook Saving

Mar 5, 2010

How do I get a shared workbook to automatically save upon every change by each user. The only way I can get this to work (at this point) is to run a macro that updates every 45 seconds IN EACH WORKBOOK! It's counterintuitive because the workbook is shared (on a network), but each user must start the "time" macro in their "individual" SHARED workbook to allow the automatic saving.

What am I missing? There has to be a more efficient way to do this, right?

Code below
HTML Sub Time()

Call Save
Application.OnTime Now + TimeValue("00:00:45"), "Time"

End Sub

HTML Sub Save()

ActiveWorkbook.Save
End Sub

View 9 Replies View Related

UserInterFaceOnly In Shared Workbook

Nov 16, 2006

I have a workbook that i am trying to make a shared workbook.

Shared workbooks have all kinds of functionality limitations. The one specifically giving me problems is the ability to protect workbooks.

Once a workbook is shared it's protection cannot be changed.

I protect a workbook prior to sharing and set the UserInterfaceOnly property = true (this allows my code to do whatever it wants but still maintains protection in the user interface).

Once i share and excel makes me save, everything works super and all the code in my auto_open macro works perfectly. But as soon as i close and open the file it seems that the UserInterfaceOnly property i set to true turns off and my code stops working.

Because it's a shared workbook i cannot turn it back on in the auto_open because that functionality is disabled.

View 6 Replies View Related

Charts In Shared Workbook

Jan 9, 2007

We have a worksheet, which contains charts and data which requires updating by different department.

However, when I have this work- book as a Shared workbook (Tools - share workbook), The charting and macro has all been deactivated.

Would anyone have any idea on how do I share a workbook - while being able to also update the Excel Charts within it ?

(Different user will be updating different charts, and there will be no conflict in between them)

View 3 Replies View Related

VBA Save Workbook As Shared Workbook

Aug 30, 2012

HTML Code:

Private Sub SaveAsAndShare()
ActiveWorkbook.SaveAs Filename:= _
"S:LdnPath1Path2Path32012Folder1Folder 2Aug12ReportName " & Format(Date, "MM-DD") & ".xlsx", FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False
End Sub

HTML Code:

ActiveWorkbook.SaveAs FileName, , , , , , xlShared

My code is the first bit, the 2nd code I found from another post, I want to add xlshared to my code above so it is shared when saved down.

View 4 Replies View Related

Track Changes Without Switching To A Shared Workbook

May 21, 2009

Which version of excel allows you to do a Track Changes without switching to a shared workbook? I am awared the Excel 2002 version allows Track Changes on the conditioned that the workbook is switch to shared mode.

View 3 Replies View Related

Shared Workbook Scrolling And Views

Oct 6, 2009

1. I have a shared and protected workboook that about 15 people update. For some reason, when people open it they can't always scroll. Anyone know why this happens and how to fix?

2. Is there a setting so that whoever opens the workbook will see the same view (instead of whatever view the last person saved the file in)?

View 10 Replies View Related

Personal View Of Shared Workbook?

Nov 8, 2011

Is there a way to setup personal views of a shared workbook ? For eg : I might hide columns f to j and the other person might have to hide columns h to m. Also, one person might be using ver 2003 and other person using 2010.

View 2 Replies View Related

Shared Workbook: Revision History

Aug 18, 2009

Our main spreadsheet in the office is a shared filed which is accessed by 3 pc's.
We have been using this set-up for nearly 3 years and no problems until this last week. Now, over the past week, this message pops up when we try to save the file on the PC's not hosting the file.

"Excel was unable to save the workbook because there was a problem reading or applying part of the revision history. You can unshare the work book or save to a non shared workbook format to fix the problem"

I have shared/unshared/reshared and shared again but a week later, I still keep getting this message popping up. Any ideas?

One thing I have noticed is that we have set it in the advanced tab of the share workbook options not to keep revision history, but sometimes it also shows 'keep history for 30 days'.

View 9 Replies View Related

Move Picture In Shared Workbook

Sep 8, 2006

i have a workbook with picture and that workbook in share mode.

i have to move picture in share mode.

View 4 Replies View Related

Protecting Cells In Shared Workbook

Oct 27, 2006

I have a shared workbook is it at all possible to leave the cells unprotected so a user can enter data but prevent cells from being formated

for instance someone on night shift with nothing better to do has decided that black text on a white background is boring and changes it frequently to a rainbow of colors. and text types
it is making a well laid out and good sheet look like something a child has done
I would pursue this down a discipline line but it has proved impossible to nail down the culprit from the many users

View 5 Replies View Related

Capture First User Of A Shared Workbook?

Feb 28, 2007

Using Excel 2000, I have a shared workbook which is effectively a single sheet, flat database. Rows contain dates, and when certain dates occur, I want to send an email alert to specific users. I have searched and found lots of guidance on that aspect, but am wondering how best to trigger the email alert. At least one, and up to 10 users access the shared workbook at different times of day, and I only want to review the data and send the email alerts to the relevant users once per day.

I thought about a timed event, but cannot be sure the shared workbook will be open. I wondered whether an event in Personal.xls might do it, if I ensure I open Excel every day, but it's not ideal. Finally, I wondered if I could somehow trigger the alerts when the first user opens the workbook - but can't find how to capture that.

View 2 Replies View Related

Advanced Filter In Shared Workbook

Jul 24, 2007

Can you use or apply advanced filters in a shared workbook?

I have a workbook project where I am dynamically applying advanced filters through VBA.

The intention is to share the workbook at some point for data entry among a group of people. I did not see advanced filtering listed in Excel Help as one of the features that are not available, but I did note that if I try to apply one through the menu bar it is greyed out in a shared workbook (autofilter is still available).

View 4 Replies View Related

Sheets Missing In Shared Workbook

Sep 8, 2007

SETUP: I have a shared workbook that is accessed by many people. It is designed to control the flow of work during the monthly close process. These processes are controlled by macros. There are 40 sheets in this workbook.

PROBLEM: On of my location's workbooks frequently loses half of it's sheets in the workbook. Counted in the neighborhood of 14 to 19 sheets go missing.

EFFORTS: I have attempted to Delete, Cut, Move, etc... these sheets with no success.

Only when I put the file in an exclusive state can I manipulate the sheets.

View 7 Replies View Related

Macro Fails In Shared Workbook

Sep 25, 2007

I have a workbook which I need to give shared access.

The workbook has macros which make sheets visible and VeryHidden and also give certain sheets protection. Also a filter runs on one sheet.

When I give the workbook shared access, the macros error?

how I can give me workbook shared access but still allow the macros to hide/unhide sheets, filter and protect worksheets?

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved