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?

ADVERTISEMENT

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 View Related

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

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

VBA - Opening A Workbook On A Network

Sep 29, 2009

As above i have a macro which opens a workbook which is on a network drive. This works fine for my multiple users...however i have discovered that if they do not have the drived mapped with the same drive letter at the start...it will throw up an error advsing that the file does not exist. Is there any way to by pass this.

Ex - "TestFile.xls"

File is stored in "E:NetworkTeam1Testfile.xls"

However, some users have access to this file and it is mapped as E:, but some users have been mapped as F: The advisors who have been mapped as F: cannot access the file. Is the VBA/Macro smart enough to bypass the drive letter and just search the rest of the past...NetworkTeam1Testfile.xls".

View 2 Replies View Related

Saving To Next Empty Row - Closed Workbook Over Network

Nov 15, 2012

I have the macro that is supposed to save to the next empty row to a closed workbook in a shared network drive. But I am getting an error saying that Excel cannot open the workbook.

Code:
Private Sub CommandButton5_Click()
Workbooks.Open Filename:="phgbsorgad03.ph.gbsorg.netmembersmigsCall_Form_Dbase.xlsm"
Sheets("Database").Activate
Application.ScreenUpdating = False

[Code] ........

View 2 Replies View Related

Slow Workbook When Connected To Local Network

Apr 26, 2009

I have Excel 2003 SP3 on Vista Home Basic fully patched. My code runs very slowly until I pull out the ethernet cable then it runs quickly.

View 9 Replies View Related

Track Changes In Workbook By User Name

Jun 27, 2008

I am unable to add which user made the change to the specific cell. The code used is:

Dim vOldVal 'Must be at top of module
Private Sub Worksheet_Change(ByVal Target As Range)
Dim bBold As Boolean
If Target.Cells.Count > 1 Then Exit Sub
On Error Resume Next
With Application
. ScreenUpdating = False
.EnableEvents = False
End With
If IsEmpty(vOldVal) Then vOldVal = "Empty Cell"
bBold = Target.HasFormula
With Sheet1
. Unprotect Password:="Secret"
If .Range("A1") = vbNullString Then
.Range("A1:E1") = Array("CELL CHANGED", "OLD VALUE", _
"NEW VALUE", "TIME OF CHANGE", " DATE OF CHANGE")
End If..................................................

View 3 Replies View Related

Force Links To Reference Linked Workbook Network Folder

Apr 4, 2008

The situation is that I have created a workbook in a network folder: xprojectsexcelclientAApril
umbers

The workbook links to a few other workbooks on the same network, but in the parent folder: xprojectsexcelclientAApril

The problem occurs when my colleagues have to updates the links in the main workbook, because they have not mapped the network drive in the same way as I have. The problem is NOT the prefix, but the fact that they have a more direct link to the network folder. My collages have mapped the folder like: xclientAApril
Is there a way where I can make the links in the workbook, so they don't depend on the entire string, but only on the fact that it is in the parent folder?

View 3 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

Track Number Between Two Tabs On Same Workbook

Mar 18, 2009

I'm trying to see if the same numbers exists in two different spreasheets on the same workbook. Both "asset tags" columns are sorted ascending. If the number appears on both table I would like my formula to add a "Y" (for yes) on the proper cell. Not sure if I should use Vlookup, sumproduct or sumif formula. Here is the main table where I want that "Y" to appear in Column D .....

View 9 Replies View Related

Share Workbook Option Disabled Ė Canít Share Workbook

Mar 26, 2008

I have a large worksheet that for some reason I canít share.

-It does not have any lists, that I know of, do not know how to see if there are any
-It does have validation, but I have other workbooks with listed validation that are shareable
-It is not protected
-Does not have any named ranges
-Is not read only
-I have saved it as another file name and no luck there
-I have copied the one sheet I really need into a separate file to try that it did not work,

View 2 Replies View Related

Excel 2010 :: Opening Shared Workbook On Network Drive - Set Permissions?

Aug 20, 2013

I currently have a password secured excel file on my departs Q drive, which everyone can access unfortunately only 1 person can edit at a time. I tried to turn it into a workbook so we could all edit it at the same time but now some of the other users can't access the file at our other buildings throughout the county. This is for excel 2010. And I did select the share workbook, and allow multiple users to edit box. everything else is unchanged.

View 3 Replies View Related

Track Time Spent Active In Workbook?

Aug 26, 2013

My team and I are attempting to track how much time we are spending in each Excel workbook we create (all workbooks are created from a single template). The problem is that we are often jumping back and forth between different workbooks throughout the day so manual entry methods are neither accurate or practical. Is there a way, with macros or formulas, to embed a time tracker in the template workbook that would only record active (when workbook is selected) time in the workbook?

View 3 Replies View Related

Macro Button Disabled When Workbook Date / Time Created Different Or More Than Time Set

Mar 7, 2014

I have a workbook with macro button to run some vba, if i want the button to disable when the user make copies of the workbook (date created is later than original wb saved time) what codes to add in the VBA?

what i assume is to add the time to a cell when the wb is saved, when the wb opens, it check for that cell if the same with the date created, if different, then disable the macro button.

View 9 Replies View Related

Disabled Tools

Jan 21, 2010

Just discovered the drawing tools on my quick access tool bar are disabled. All were enabled and working fine just yesterday. I'm running 07 on xp. I've shut down and rebooted, no change. Need to know how this could have happened but mostly, how to enable.

View 9 Replies View Related

Save As PDF With Printing Disabled?

Jan 21, 2013

Is there a way to save a document as a PDF but with printing disabled?

View 3 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

Can Page Tabs Be Disabled?

Jul 19, 2007

I am creating a workbook and need the user to stay on a single page of the workbook until certain circumstances have been met, specifically, a macro has been activated, thus confirming that certain data is now in place. Is there a code of function that I can introduce into the workbook so that clicking on the other tabs of the other sheets will not allow the user to leave the page they are on until that circumstance is met?

View 9 Replies View Related

Disabled Not The File Close

Sep 25, 2009

I have this code that I've sourced from the internet, i have used to disable red "X" on the top right,

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Cancel = Not bClose

If Cancel = True Then MsgBox "Please Save your data and select File - Close from the main menu"
End Sub

but when I select File and then close .... it runs the same macro? eh? i want x's disabled not the file close ....

View 9 Replies View Related

Insert Functions Disabled

Feb 23, 2010

I have a worksheet that all of the icons that start a macro disappeared. The workbook will not let me insert a pic, or clipart. Nothing is locked.

View 9 Replies View Related

Some Sub-Menus Disabled - Greyed Out

Nov 6, 2006

I have noticed that the submenus for the following main menu items are disabled

Edit Insert Format Data

The submenus for the other main menu items are fine.

I have not run any macros that alter the menus.

I have tried Tools>Customise Reset Menu and Toolbar usage. I then exit the Excel session, but the problem still remains,

View 3 Replies View Related

Cancelling Events Disabled?

Jul 14, 2007

The boolean Cancel suddenly stopped working for me in all workbook and worksheet events. Consider a simple example:

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
End Sub

does not cancel right click, like it has before. Same with BeforeDoubleClick. I can only assume it is some kind of a setting or similar, as there is absolutely no change in the code.

View 4 Replies View Related

Macro Cannot Be Found Or Is Disabled Error

Mar 7, 2013

I have a worksheet with several option buttons and until yesterday, I had no problem selecting them. But today, every time, I select a radio button, an error shows up stating "Cannot run Macro "Option Button_click. Macro is not available in this workbook or is disabled". When the user selects a radio button, text appears in Col B depending on what button was selected (using VLOOKUP). That stuff is still working fine. It's just as soon as I click a radio button, the error shows up.

Based on the radio button selected, user can add in information to the columns adjacent to it, and then click a button to store that information in some rows below. The code for that button is stored in the sheet module. I have tried enabling macros and disabling macros and no change has appeared. What I have noticed though is that yesterday, when i opened the workbook, a yellow bar appeared asking if I wanted to "Enable Content". Today, that bar didn't appear.

View 1 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

Disabled Properties Menu Option

Apr 9, 2009

I'm using excel 2003 and received a file that has the properties (file/Properties) menu option grayed out. I need to access the properties menu to identify file information.

View 6 Replies View Related

Hide All Sheets When Macro Is Disabled?

Aug 2, 2014

continued from: [URL]

Option Explicit forces explicit declaration of all variables in the code. That is why i had to declare ws as worksheet using the Dim statement before using it in the code. It is recommended to have it - however for this code it wouldn't have mattered.

I'm not sure I exactly follow what you imply here. But yes, you can hide all the sheets at first and then "unhide" at the start of the macro. Let's say you have a "Start" sheet.. then:

[Code] .....

The workbook is used by other people too. I cannot just tell them to hide the sheets, it defeats the purpose. What I want is, when macro is disabled, they will only see the START sheet, otherwise, all sheets will be visible. To add to this, a new sheet is added everyday. Sheets name are calendar dates in mmdd format

View 4 Replies View Related

Macro Disabled Depending On Cell Value

Sep 24, 2009

I was wondering if it is possible to prevent a macro from running depending on what value is in a specified cell.

I have a huge excel sheet and a commandbutton that runs a bunch of macros in order to generate a report.

I want to force the user to select a specific project before all the macros are run. Just making the report for a specific project only takes a few seconds but if no project is selected then it runs throught the whole database and it takes forever.

I have set up a cell that changes value depending on wether a project is selected or not. I have placed the cell in the -ForMacros- sheet. Now is it possible to write some code into the commandbutton that halts the report generation + displays a warning box telling the user to select a project first?

What values used to determine wether the macro runs or not doesnt matter to me. Whatever is easier for you

I have attached a sample workbook for you to work on.

View 6 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

Menu Items Disabled While In Formula Bar

Oct 3, 2007

How do I disable a custom menu item when a user is entering data in a cell?

For example... when the formula bar in Excel has focus, and a user tries to select Data > Sort, the Sort item is disabled. But when the focus is back to the worksheet, Data > Sort is enabled.

I need to do the same thing for my custom menu items.

View 5 Replies View Related

Grouped Rows Disabled When Protecting Worksheets?

Nov 1, 2013

I have a protected worksheet which enables only certain sections to be edited, data inputs etc. I also have a set of rows grouped which need to be activated depending on data type for particular projects to be captured. Problem is, when the sheet is protected, when users click on the + and - buttons to either ungroup and group the rows depending on type of project, this feature is disabled.

I get a popup alert that tells me "You cannot use this command on a protected worksheet. To use this command you must first unprotect the sheet ....". Problem is I don't want all users to have access as giving them the password defeats my purpose of protecting the sheet.

See the attached file, row 23.

View 9 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

Excel 2010 :: Filter By Color Has Become Disabled?

Oct 26, 2012

I have a workbook in Excel2010 with 2 sheets. I have put in a conditional formatting in 27177 cells. After a lot of waiting it finally worked out and the cells that should turn RED, do show correctly. The strange thing is that my "filter by color" stays disabled. This applies both to the columns I've applied the conditional formatting to, as well as any other column that has a colored cell.

The second sheet in the file also have colored cells and there the option works perfectly fine. So it seems to have something to do with the particular sheet.

why the function got disables in the particular worksheet.

View 1 Replies View Related

Undo Button Disabled Once Report Opened Containing VBA?

Jun 10, 2014

I do have a VBA that runs in the report. For whatever reason this stops excel back button (or CRTL Z) from working. What would i need to change in order for back button to work?

I know it is due to this VBA since all other spreadsheets are working fine and as soon as i open this spreadsheet undo button stops functioning.

Private Sub Worksheet_Calculate()
Dim MyPic As Picture
Me.Pictures.Visible = False
Pictures("Picture 11").Visible = True
With Range("AH1")
For Each MyPic In Me.Pictures
If MyPic.Name = .Text Then

[code].....

View 1 Replies View Related

Can't Assign Shortcut To Macro: 'Options...' Button Disabled

Feb 23, 2010

I'm trying to assign a shortcut to a macro I wrote in VB. However, when I go to Tools->Macros->Macros, none of my macros (whether coded in VB or recorded) have the "Options..." button enabled, so I can't assign the macro. This happens whether I use Excel 2003 or Excel 2007. The file is not readonly and I have tried the various levels of macro security. I have VBA installed.

View 5 Replies View Related

Pivot Table :: The Query And External Data Source Is Disabled

Feb 5, 2007

In pivot table field Setting > Advanced > page field option, the selection for "the query and external data source is disabled. How do i enable it.

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

Network Print Is Required

Feb 23, 2014

I recorded a print macro which prints to my default printer, others will be using this spreadsheet so I really need it to print to the same network printer. The printer address and name is: ironyan-fileBI44

How do I incorporate this into my code?

[Code] .....

View 7 Replies View Related

Working With PC Network Names?

Jun 3, 2014

Is it possible to retrieve the network name of the local workstation and if so how?

View 2 Replies View Related

Saving To A Network Drive

Jan 6, 2009

We have a form that is completed by our employees and emailed to a central group email address that up to 8 employees within our team can access. When one of our 8 team members open the file sent they need to add comments to it and then save it in a central directory on one of our network drives.

Now the problem I have is that we all have the network drive mapped to a different letter.

Is there a way that I can have a macro (see below for current macro that does not work) save to a network path and not a drive letter.

View 10 Replies View Related

Changing Network Printers

Apr 15, 2009

I have a command button in a spreadsheet with the following code attached to it

View 4 Replies View Related

ADVERTISEMENT