Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Can anybody stop this happening please
Hi
i have a excel invoice - In cell H15 is a invoice number which is stored in another exel workbook - and each time my invoice template is opened it increments by 1. Could anyone please explain simply and easy to understand terms - how i save a copy of the invoice (after filling it out) - and be able to open it to ie edit or veiw (the copy) without the invoice number on the copy adding one and throwing out my invoicing number system. Here is what i have - and im on excel 2000 IN THE WORKBOOK CODE Private Sub Workbook_Open() Application.ScreenUpdating = False Workbooks.Open Filename:="C:\Documents and Settings\Pam\My Documents\Invoice\InvoiceNumber.xls" ActiveWorkbook.Save ActiveWorkbook.Close Application.ScreenUpdating = True End Sub IN the invoice template - cell H15 is a path to the InvoiceNumber.xls - Can someone please tell me what i should do - iv checked links on the answers page to websites - but they a bit hard to disypher and pick around. many thanks |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Can anybody stop this happening please
Open the workbook in Office Safe Mode. The Event macro will not run and the
invoice number will not increment. -- Gary''s Student - gsnu200769 "Pammi J" wrote: Hi i have a excel invoice - In cell H15 is a invoice number which is stored in another exel workbook - and each time my invoice template is opened it increments by 1. Could anyone please explain simply and easy to understand terms - how i save a copy of the invoice (after filling it out) - and be able to open it to ie edit or veiw (the copy) without the invoice number on the copy adding one and throwing out my invoicing number system. Here is what i have - and im on excel 2000 IN THE WORKBOOK CODE Private Sub Workbook_Open() Application.ScreenUpdating = False Workbooks.Open Filename:="C:\Documents and Settings\Pam\My Documents\Invoice\InvoiceNumber.xls" ActiveWorkbook.Save ActiveWorkbook.Close Application.ScreenUpdating = True End Sub IN the invoice template - cell H15 is a path to the InvoiceNumber.xls - Can someone please tell me what i should do - iv checked links on the answers page to websites - but they a bit hard to disypher and pick around. many thanks |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Can anybody stop this happening please
Pammi J
This is an extreme way and if you have a lot of invoices it may be to time consuming, but you could delete the sub routine that increments the invoice numbers from saved worksheet. Or maybe one of those that speak VBA could alter the routine to check if there is a number in H15, and if so "do nothing". Just a thought! Mike Rogers "Pammi J" wrote: Hi i have a excel invoice - In cell H15 is a invoice number which is stored in another exel workbook - and each time my invoice template is opened it increments by 1. Could anyone please explain simply and easy to understand terms - how i save a copy of the invoice (after filling it out) - and be able to open it to ie edit or veiw (the copy) without the invoice number on the copy adding one and throwing out my invoicing number system. Here is what i have - and im on excel 2000 IN THE WORKBOOK CODE Private Sub Workbook_Open() Application.ScreenUpdating = False Workbooks.Open Filename:="C:\Documents and Settings\Pam\My Documents\Invoice\InvoiceNumber.xls" ActiveWorkbook.Save ActiveWorkbook.Close Application.ScreenUpdating = True End Sub IN the invoice template - cell H15 is a path to the InvoiceNumber.xls - Can someone please tell me what i should do - iv checked links on the answers page to websites - but they a bit hard to disypher and pick around. many thanks |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Can anybody stop this happening please
Hi "Gary"s Student"
that sounds good, but how do i do that? i have investigated security on the macros but it seems i can only disable securtiy on every workbook - no just the copys i save. Unless im looking in the wrong info, and its nothing to do with the security. Could you explain please thankyou Pam "Gary''s Student" wrote: Open the workbook in Office Safe Mode. The Event macro will not run and the invoice number will not increment. -- Gary''s Student - gsnu200769 "Pammi J" wrote: Hi i have a excel invoice - In cell H15 is a invoice number which is stored in another exel workbook - and each time my invoice template is opened it increments by 1. Could anyone please explain simply and easy to understand terms - how i save a copy of the invoice (after filling it out) - and be able to open it to ie edit or veiw (the copy) without the invoice number on the copy adding one and throwing out my invoicing number system. Here is what i have - and im on excel 2000 IN THE WORKBOOK CODE Private Sub Workbook_Open() Application.ScreenUpdating = False Workbooks.Open Filename:="C:\Documents and Settings\Pam\My Documents\Invoice\InvoiceNumber.xls" ActiveWorkbook.Save ActiveWorkbook.Close Application.ScreenUpdating = True End Sub IN the invoice template - cell H15 is a path to the InvoiceNumber.xls - Can someone please tell me what i should do - iv checked links on the answers page to websites - but they a bit hard to disypher and pick around. many thanks |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Can anybody stop this happening please
1. leave your security setting alone.
2. hold down the CNTRL key and, while holding it, start Excel 3. confirm to Excel that you want Safe mode 4. open your file from that instance of Excel 5. Excel will complain about the macros, but will open the workbook with macros disabled Because macros have been disabled, the invoice number in H15 will not increment. This is only a temporary situation. The next time you use Excel, it will behave normally.. Safe Mode is a good way to open a workbook without unwanted events occurring. -- Gary''s Student - gsnu200769 "Pammi J" wrote: Hi "Gary"s Student" that sounds good, but how do i do that? i have investigated security on the macros but it seems i can only disable securtiy on every workbook - no just the copys i save. Unless im looking in the wrong info, and its nothing to do with the security. Could you explain please thankyou Pam "Gary''s Student" wrote: Open the workbook in Office Safe Mode. The Event macro will not run and the invoice number will not increment. -- Gary''s Student - gsnu200769 "Pammi J" wrote: Hi i have a excel invoice - In cell H15 is a invoice number which is stored in another exel workbook - and each time my invoice template is opened it increments by 1. Could anyone please explain simply and easy to understand terms - how i save a copy of the invoice (after filling it out) - and be able to open it to ie edit or veiw (the copy) without the invoice number on the copy adding one and throwing out my invoicing number system. Here is what i have - and im on excel 2000 IN THE WORKBOOK CODE Private Sub Workbook_Open() Application.ScreenUpdating = False Workbooks.Open Filename:="C:\Documents and Settings\Pam\My Documents\Invoice\InvoiceNumber.xls" ActiveWorkbook.Save ActiveWorkbook.Close Application.ScreenUpdating = True End Sub IN the invoice template - cell H15 is a path to the InvoiceNumber.xls - Can someone please tell me what i should do - iv checked links on the answers page to websites - but they a bit hard to disypher and pick around. many thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
O.T. What's happening in the Newsgroups? | Excel Discussion (Misc queries) | |||
Don't know what is happening.... | Excel Discussion (Misc queries) | |||
Impossible- but it's happening! | Excel Discussion (Misc queries) | |||
Why this is happening | Charts and Charting in Excel | |||
Why is this happening? | Excel Worksheet Functions |