Code To Turn Share On/off

Aug 28, 2007

Need code to disable and enable "Protect and Share Workbook"?

View 9 Replies


ADVERTISEMENT

Turn VBA Code On / Off With Button

Feb 25, 2012

I have a series of sheets in my workbook , each sheet has a piece of VBA code that is identical. On my master sheet I want the user to be able to turn on/off this piece of code with the toggle of a button.

My code is a :Worksheet change event

Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("B9,D9,")) Is Nothing Then Exit Sub
If Target.Offset(-1, 1) = "" Then.......
.....
End If
End Sub

View 7 Replies View Related

Turn Off Messages While Typing Code

Oct 31, 2008

Is there a way to turn off those annoying error message boxes that pop-up when a line of code is incorrect? I pretty frequently go to another area of code to grab some previous code to copy and paste, and the error message box pops-up, so I have to hit OK to close it. It would be nice if it still highlighted the problem red, but I'd even give that up for those boxes to go away.

View 5 Replies View Related

VBA Code To Turn Off Another Running Macro

Jan 5, 2012

I have a macro, that basically runs a sub routine to count down say for example 1 min, at which time the workbook closes. However if the user opens one of the forms I would like to turn off the background timer macro. How can I do this with code? Is there code that does the opposite of 'application.run'?

View 1 Replies View Related

Turn On View Vba Code In Apple MAC Office 2008

Aug 19, 2009

how i can turn on view vba code in Apple MAC office 2008.

View 3 Replies View Related

Share Workbook With "Allow Changes By Multiple Users" Code

Aug 8, 2007

Although i am using VBS, the coding should be similar. I am looking for all Excel files in a folder (WORKING) and determining if they are shared, allowmultipleusers, (WORKING). The problem I am encountering is changing the Excel workbook to a [SHARED] workbook. By that I mean Multiple users can open and make changes. What is the syntax to enable that? As an FYI I can save the [SHARED] workbooks as exclusive (normal), but not the reverse. I have tried Saveas,,,,,,xlshared, but is not working. Here is the VBS code I have (For grins)

Const APPLICATION_DATA = &H1a&
Set objShell = CreateObject("Shell.Application")
'Set objFolder = objShell.Namespace("L:Shared Services Stock Rotation ReviewRotations for Review")
Set objFolder = objShell.Namespace("C:Documents and Settingsmhast14DesktopRotations for Review")
Set objFolderItem = objFolder.Self

Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objExcel = CreateObject("Excel.Application") ..............

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

Turn #DIV//0!” To “0” Or Even Turn It To A Blank Cell

Nov 6, 2009

I have a workbook which is set up to take an average heart rate of a participant from a series of data points. I have set the spreadsheet up before I have collected some of the data. (so I can review the project at the 3 months period and its an ongoing project).

The problem is that if there is no data in a participants column then excel correctly gives you readout of “#DIV//0!”. On my results page this #DIV//0!” makes it hard to read the spreadsheet. Is it possible to get excel to turn #DIV//0!” to “0” or even turn it to a blank cell?

View 5 Replies View Related

Conditional Properties: If A Number In A Different Cell Is Above A Certain Number It Will Turn Green And Another Cell To Turn Red

Dec 10, 2008

can I set a cell in excel so that if a number in a different cell is above a certain number it will turn green and another cell to turn red. I have attached the file.

View 4 Replies View Related

How To Share Codes

Apr 1, 2008

I have written a VBA code.

I thought I could just save it as an ADD-IN and then have my colleagues to add it, but that does not work. The macro will be stored in a seperate workbook and that is not what I want. I want them to be able to open any workbook and want them to be able to run the macro. I.e. everytime they open a workbook the macro should be available and be ready to run.

View 9 Replies View Related

How To Access A Share Workbook

Jun 12, 2014

I need to know that how can we share excel workbook. Is it possible over LAN? Also how many users can access the shared workbook. If 50 users are accessing shared workbook and each one working on different workbook. Is this scenario feasible? Will there be any issue if 50 users working on 50 different worksheets of same workbook?

View 2 Replies View Related

Share Excel In The Company?

Aug 14, 2014

My company has a lot of file excel. I usually use Google driver, LAN and a lot of the other ways to share file to all member in the company. But so, it is time consuming very much and not protect information in my execl file.

View 5 Replies View Related

How To Share Workbook With Tables

Feb 3, 2011

I have a workbook full of tables and pivot tables. When I try to share it tells me to convert the tables to ranges or to something about XML.

View 6 Replies View Related

Use Excel In Share Mode?

Jan 3, 2013

We have a spreadsheet at work that is saved as Micosoft.xlsx [share].

I think the "[share]" means that more than one person can access it at the same time. How do you create a document like this.

View 3 Replies View Related

How To Share Macro(s) To Other Users So They Can Use It

Jan 7, 2014

How do I share a macro(s) to other users so they can use it? Each user has different location because we are working remotely.

View 1 Replies View Related

Loop Through Files On Share

May 30, 2008

I have the following code, and it is working well for one file. I'm trying to figure out how to do a loop to go through each region folder and update, save, and close each file just like the code below is doing for one file.

There are 10 region folders
Each region folder contains 8 or fewer files.

Please see the sample code below for the sample file location.

Sub TrendByRegion()

Application.EnableCancelKey = xlDisabled

Set wbOpen = Workbooks.Open(Filename:= _
"S:High Level ShareReportsReports by RegionPivot Table Files
Region 1Catalog File.xls")

wbOpen.RefreshAll

ActiveWorkbook.Save

ActiveWorkbook.Close

End Sub

View 9 Replies View Related

Share Workbook While Openning It

Sep 17, 2006

I have a workbook which is used by over 100 people. It is turned on to share mode, but to ensure it would stay like that I need the workbook to check whether it is shared while being opened and then turn to share mode in case this would not be the fact.

View 4 Replies View Related

File Not Share Due To Tabs Or XML Maps

Jul 3, 2014

I have an excel document that I wish to share for multiple users to edit, but get the following error message Excel tabs or XML maps.

View 3 Replies View Related

Document Saved On Network Share?

Feb 27, 2013

My coworkers and I use a couple of Excel documents to store statistics. The document is on a network share. We all have Office 2010, my coworkers are on Windows XP, I am on Windows 7.

If I open the document and make changes, then save it to the network location I can open the document later and see the changes but my coworkers do not see any changes I have made. Also If my coworkers make changes to the document the 3 of them see the changes but I do not.

If I go straight to the network share the timestamp on the document only changes for changes I made.For example if I go to servernamefoldernamestats.xls and add data to the file. Then save and close it. I can reopen the file and my changes are there.

Tomorrow Coworker 2 opens the same file from the same location but it has data from 2 days ago, with a timestamp of 2 days ago and my data is missing. They then reimput the data I entered, and add todays data. Then they save it and close.I open the file it has my data from yesterday, but not the new data entered by coworker 2.

View 3 Replies View Related

Share A Toolbar That Calls Macro From An Add-in

Mar 14, 2008

I have created some macros that need to be used in several workbooks by more than one users, so I put them in an add-in and gave them instructions on how to get the add-in. I also created a toolbar with buttons calling those macros, attached it to a workbook the users can open, and instructed them to open that workbook once to get the toolbar.

Both the add-in and the toolbar workbook are on a network drive that my users can access, but when they get the add-in, it gets copied to their own add-in folder.

Here's my problem:
When a user tries to click on one of the buttons in the toolbar, the button tries to call the macro using the path that would be valid on my computer to get to my add-in folder. This path includes my user name, so it doesn't go to their own add-in folder: it goes to my add-in folder on that computer if I ever logged in on that particular machine, or it goes nowhere.

When I created the button, I attached the macros by referring to the add-in workbook by name only, without referring to a path, so I don't know why MY path ended up defined on that toolbar.

How can I go around this? I manually relinked all the buttons for that user, and I can do it for the other users (there aren't that many users nor that many buttons), but I'd rather avoid it: I'll have to re-do it if the toolbar is updated and it just seems like more work than should be necessary.

I'm also opened to suggestions on a better way to share those macros. They can't be attached to the workbooks because we use new workbooks every year - they're emailed to us by the people who create them and for a variety of reasons, pasting everything into a workbook of our own is not a good option.

View 11 Replies View Related

Share The Workbook With A Number Of Users

Apr 3, 2009

I have a workbook, that has a lot of VBA code, & Userforms. I need to be able to share the workbook with a number of users.

View 13 Replies View Related

Multiple Spreadsheets Share The Same Macro

Feb 3, 2010

I currently have a macro that can be used by multiple spreadsheets. Is there that I can execute the macro within any specific spreadsheet without saving it in each spreadsheet. I just want to place it in a general spot so that in case there is modifications, I only have to change it in one place.

View 14 Replies View Related

Combining 2 Rows That Share 1 Cell

Feb 27, 2013

combining 2 rows that share 1 cell so that it is easier to format cells. For example: A4 and A5 have been combined with B4 and B5 to form 1 cell that has content. How can I convert this to a cell that only occupies A4?

View 1 Replies View Related

Search File On Share Point?

Jun 20, 2014

I need to read an excel file on share point. The file name is like 'file_name.Vx.x.xls'

Where x.x is an incremental and can change. How can I retrive the correct name?

View 1 Replies View Related

Share A Working Worksheet To Have Feedback

Jun 1, 2008

Is there a way that I can share a worksheet that I am working on so people can view it in order to have feedback?

View 9 Replies View Related

Have To Show Market Growth And Share

Jul 13, 2006

I have access to a huge database in excel that involves sales data. The database is catagorized like:

Column A = Country
Column B = Product
Column C = Company
Column D = (Product) category
Column E = Sales
Column F = Period
Column G = Sales of particular company
Column H = Market category
Further details: see attached file!

I am looking for way to express developments ( absolute and relative) in market growth and market share over time.

I have 3 questions:
How can i show the growth of the total market sales over time (period 1 to 4)?
How can i show the growth of the Int comapny sales over time (period 1 to 4)?
How can i show the market share of the Int company over time (period 1 to 4)?

Market growth can be calculated by comparing the sales amounts of the total market (or the Int company) to previous periods. Market share can be calculated by expressing the sales figures of the Int company in percentage of the total sales in a partical period (i=1,2,3,4).

View 6 Replies View Related

Unable To Share Macro As Add-in Or Template

May 4, 2007

I created a macro in VBA that pops up a calendar with keyboard short cut and places the date in selected cell. It works great on my pc. I can't share the macro with anyone. I saved it as an add-in...installing the add-in did nothing. Then I saved it as a template...the template did not open with any macros associated. both cases, no errors. no message to enable to disable macro.

View 4 Replies View Related

Share Spreadsheet With Multiple Users

Sep 11, 2007

I have a speadsheet, and at the moment, another spreadsheet access it via a vb code. but i have 3 - 5 agents needing it sometimes at the same time. All that happens, is the agents excel sheet passes some info to the server sheet, so the vb codes opens and closes it. So only one person can do it at the same time.. but i need this so anyone of the agents can enter info via the vb code.

When i tested it, it asked me when i opened it, if i wanted to save what the last person did, I need that not to come up, so really its like the sheet is always open, but not... and lines are added. The info is added to the same sheet, and line by line.

View 2 Replies View Related

Highlight Rows That Share Text Across Columns

Feb 15, 2013

I am wondering how I can highlight rows that contain the same text across selected columns (not all). For example, consider the following table:

ID#6527
Jay
yellow
dog

[Code]...

I want to focus on Columns B, C, and D. I would like rows 3 and 5 to be highlighted, since they share the same text across the target columns. I assume this can be done via a formula in Conditional Formatting, but I'm not sure.

View 3 Replies View Related

Warn If Two Columns Share Same Data In Two Or More Rows

Feb 19, 2014

Right now I have a script that will highlight any rows where columns "Unit1" and "Unit2" share the same value.

The script is below:

[Code] .....

How to modify this so that it only highlights rows where the same data is duplicated twice?

For example if both columns had "The dog runs" as their value in the same row, then this would only get highlighted if two or more rows on the sheet also had "The dog runs" for both their value.

Example: example.jpg

View 7 Replies View Related







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