Code To Turn Share On/off
Aug 28, 2007Need code to disable and enable "Protect and Share Workbook"?
View 9 Replies
ADVERTISEMENT
Turn VBA Code On / Off With Button
Feb 25, 2012I 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
Turn Off Messages While Typing Code
Oct 31, 2008Is 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 RelatedVBA Code To Turn Off Another Running Macro
Jan 5, 2012I 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 RelatedTurn On View Vba Code In Apple MAC Office 2008
Aug 19, 2009how i can turn on view vba code in Apple MAC office 2008.
View 3 Replies View RelatedShare Workbook With "Allow Changes By Multiple Users" Code
Aug 8, 2007Although 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") ..............
Share Workbook Option Disabled Cant Share Workbook
Mar 26, 2008I have a large worksheet that for some reason I cant 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,
Turn #DIV//0! To 0 Or Even Turn It To A Blank Cell
Nov 6, 2009I 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?
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, 2008can 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 RelatedHow To Share Codes
Apr 1, 2008I 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.
How To Access A Share Workbook
Jun 12, 2014I 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 RelatedShare Excel In The Company?
Aug 14, 2014My 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 RelatedHow To Share Workbook With Tables
Feb 3, 2011I 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 RelatedUse Excel In Share Mode?
Jan 3, 2013We 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.
How To Share Macro(s) To Other Users So They Can Use It
Jan 7, 2014How 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 RelatedLoop Through Files On Share
May 30, 2008I 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
Share Workbook While Openning It
Sep 17, 2006I 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 RelatedFile Not Share Due To Tabs Or XML Maps
Jul 3, 2014I 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 RelatedDocument Saved On Network Share?
Feb 27, 2013My 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.
Share A Toolbar That Calls Macro From An Add-in
Mar 14, 2008I 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.
Share The Workbook With A Number Of Users
Apr 3, 2009I 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 RelatedMultiple Spreadsheets Share The Same Macro
Feb 3, 2010I 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 RelatedCombining 2 Rows That Share 1 Cell
Feb 27, 2013combining 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 RelatedSearch File On Share Point?
Jun 20, 2014I 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?
Share A Working Worksheet To Have Feedback
Jun 1, 2008Is 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 RelatedHave To Show Market Growth And Share
Jul 13, 2006I 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).
Unable To Share Macro As Add-in Or Template
May 4, 2007I 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 RelatedShare Spreadsheet With Multiple Users
Sep 11, 2007I 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.
Highlight Rows That Share Text Across Columns
Feb 15, 2013I 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.
Warn If Two Columns Share Same Data In Two Or More Rows
Feb 19, 2014Right 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
