Topic profile page for Workbook.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: Workbook.
Topic "Workbook" was discussed 44,348 times on 1,368 sites in last 3 months
Started 18 hours, 56 minutes ago (2009-12-07 13:10:00)
by rodjes
I referred a cell by accident to another workbook/sheet that every time I try to send it to someone else it just wont open for them because it says reference not found. Is there any easy way to finding the cell I referred. It is a lot of cells to go through. I know how to break links but that's not the same thing.
Started 19 hours, 52 minutes ago (2009-12-07 12:14:00)
by lefika
Re-activate open workbook without knowing the name of such workbook Hi, I need help with the following: My code opens a pop-up box allowing the user to specify the excel workbook to open from which information is then copied, to be pasted back into the workbook from which the macro is running, as follows: Dim OpenListing As ...
Started 20 hours, 15 minutes ago (2009-12-07 11:51:00)
by jaredh
Hi there I really hope you can help me. I have an excel sheet that has a list of codes and next to each code there is a price list for that particular item. What I am trying to do it: I have another workbook that I use to type up quotes. In this workbook there are 2 columns: one with the code for the item and then another with the price thereof. What I'd like to do is when I enter the ...
Started 21 hours, 6 minutes ago (2009-12-07 11:00:00)
by thompsy121
Hi All, I am currently using this method to create a back-up of the current workbook to another location using a yes/no message box. If the user clicks no, the workbook will be closed...also if they have not saved any changed data excel also gives them this option in case they close by mistake. Its the yes option i am having issues with. If they ...
Started 1 week, 1 day ago (2009-11-29 23:28:00)
by dan_pafc
Disable save option on workbook except for named macro's Hi, I want to disable all save option's in a workbook but still allow 2 macros to save the file. Im using this to disable the save option: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) If SaveAsUI = False Then Cancel = True...
Started 1 week ago (2009-11-30 17:43:00)
by groc426
Recovering VBA code in corrupt workbook Hello everyone, After lurking on the boards for a long time, while trying to advance from a beginner of VBA to a novice (still not there), I've found it now necessary to come out of the wood works. I have a workbook, which was created for work, that I have been working on for some time....
Started 1 week, 1 day ago (2009-11-30 06:38:00)
by somnath_it2006
Desable delete row operation in Shared Workbook Hello Friends, Can I disable the Delete Row or Column operations on shared workbook? Please assist... __________________ -------- Regards, Somnath "than others. That's the mark of a true professional...." - Joe ...
Started 4 days, 20 hours ago (2009-12-03 12:03:00)
by Alfonso Vicente
Hi: I'm working with Discoverer 10g over Applications (Applications users), I'm not the EUL owner but the Business Area owner. I create a new workbook with Discoverer Plus and try to share the workbook with another Applications users When these users try to open the workbook, they obtains a message: Item "" used by the workbook is missing I tried ...
Started 6 days, 23 hours ago (2009-12-01 08:44:00)
by Mike
Excel 2007 says you can have multiple users editing a workbook at same time using sharing. I can get this to work via a server using sever 2003 but when I share the file on a peer to peer network only the first person to open the file can edit it eveyone else gets a read only version. What am I doing worng....
Started 6 days, 21 hours ago (2009-12-01 10:41:00)
by Barb Reinhardt
I have a workbook that starts out at 701.6 KB. After changing about 20 cells and adding some comments, it increases to 84Meg. Does anyone have any idea what might be causing this? Thanks, Barb Reinhardt
Started 5 days, 1 hour ago (2009-12-03 07:06:00)
by cabana_boy via OfficeKB.com
Hoping someone can help me with this. I have a rather large workbook (23 worksheets) that I'm using as a sort of database (because my employer thinks Access is of the devil for some reason). I need to exclude the following sheets from printing when I do a workbook print: Foreign WD On Us-Denials-Inquiries Total Transactions...
Started 3 days, 22 hours ago (2009-12-04 09:38:00)
by Sara M
I created a shared workbook and today I am unable to open it as it is "in use by another user" and it is "locked for editing." This shouldn't happen if it's shared, should it? I can open it as read-only, but that defeats the purpose of having a shared document. What might make this happen and how can I fix it? (The workbook ...
Started 3 days ago (2009-12-05 07:54:00)
by swain.s@blueyonder.co uk
i have tried all of the following Double click 'This WorkBook' and paste the below code to the right code pane. Private Sub Workbook_Open() Workbooks.Open Me.Path & "\data.xls" End Sub Private Sub Workbook_Open() Workbooks.Open ("C:\data.xls") End Sub > Private Sub Workbook_Open() > Workbooks...