| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
about save or save as
what can i do if someone save or save as the workbook, the saved file only got numbers instead fomula, what i mean is when you save the file, you can see all the numbers and you cant put in new data. thanx -- jinvictor ------------------------------------------------------------------------ jinvictor's Profile: http://www.excelforum.com/member.php...o&userid=34099 View this thread: http://www.excelforum.com/showthread...hreadid=553118 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
about save or save as
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean) With Worksheets("Sheet1") .UsedRange.Value = .UsedRange.Value End With End Sub 'This is workbook event code. 'To input this code, right click on the Excel icon on the worksheet '(or next to the File menu if you maximise your workbooks), 'select View Code from the menu, and paste the code -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "jinvictor" wrote in message ... what can i do if someone save or save as the workbook, the saved file only got numbers instead fomula, what i mean is when you save the file, you can see all the numbers and you cant put in new data. thanx -- jinvictor ------------------------------------------------------------------------ jinvictor's Profile: http://www.excelforum.com/member.php...o&userid=34099 View this thread: http://www.excelforum.com/showthread...hreadid=553118 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
about save or save as
because the workbook is protected, so the code doesnt run properly, what can i do? thanx Bob Phillips Wrote: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) With Worksheets("Sheet1") .UsedRange.Value = .UsedRange.Value End With End Sub 'This is workbook event code. 'To input this code, right click on the Excel icon on the worksheet '(or next to the File menu if you maximise your workbooks), 'select View Code from the menu, and paste the code -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "jinvictor" wrote in message ... what can i do if someone save or save as the workbook, the saved file only got numbers instead fomula, what i mean is when you save the file, you can see all the numbers and you cant put in new data. thanx -- jinvictor ------------------------------------------------------------------------ jinvictor's Profile: http://www.excelforum.com/member.php...o&userid=34099 View this thread: http://www.excelforum.com/showthread...hreadid=553118 -- jinvictor ------------------------------------------------------------------------ jinvictor's Profile: http://www.excelforum.com/member.php...o&userid=34099 View this thread: http://www.excelforum.com/showthread...hreadid=553118 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
about save or save as
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean) With Worksheets("Sheet1") .Unprotect .UsedRange.Value = .UsedRange.Value .Protect End With End Sub -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "jinvictor" wrote in message ... because the workbook is protected, so the code doesnt run properly, what can i do? thanx Bob Phillips Wrote: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) With Worksheets("Sheet1") .UsedRange.Value = .UsedRange.Value End With End Sub 'This is workbook event code. 'To input this code, right click on the Excel icon on the worksheet '(or next to the File menu if you maximise your workbooks), 'select View Code from the menu, and paste the code -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "jinvictor" wrote in message ... what can i do if someone save or save as the workbook, the saved file only got numbers instead fomula, what i mean is when you save the file, you can see all the numbers and you cant put in new data. thanx -- jinvictor ------------------------------------------------------------------------ jinvictor's Profile: http://www.excelforum.com/member.php...o&userid=34099 View this thread: http://www.excelforum.com/showthread...hreadid=553118 -- jinvictor ------------------------------------------------------------------------ jinvictor's Profile: http://www.excelforum.com/member.php...o&userid=34099 View this thread: http://www.excelforum.com/showthread...hreadid=553118 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
about save or save as
WHY WHEN I RUN THIS VBA, IT SAYS RUN-TIME ERROR '450': wRONG NUMBER OF ARGUMENTS OR INVALID PROPERTY ASSIGNMENT. WHAT CAN I DO? Bob Phillips Wrote: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) With Worksheets("Sheet1") .Unprotect .UsedRange.Value = .UsedRange.Value .Protect End With End Sub -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "jinvictor" wrote in message ... because the workbook is protected, so the code doesnt run properly, what can i do? thanx Bob Phillips Wrote: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) With Worksheets("Sheet1") .UsedRange.Value = .UsedRange.Value End With End Sub 'This is workbook event code. 'To input this code, right click on the Excel icon on the worksheet '(or next to the File menu if you maximise your workbooks), 'select View Code from the menu, and paste the code -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "jinvictor" wrote in message ... what can i do if someone save or save as the workbook, the saved file only got numbers instead fomula, what i mean is when you save the file, you can see all the numbers and you cant put in new data. thanx -- jinvictor ------------------------------------------------------------------------ jinvictor's Profile: http://www.excelforum.com/member.php...o&userid=34099 View this thread: http://www.excelforum.com/showthread...hreadid=553118 -- jinvictor ------------------------------------------------------------------------ jinvictor's Profile: http://www.excelforum.com/member.php...o&userid=34099 View this thread: http://www.excelforum.com/showthread...hreadid=553118 -- jinvictor ------------------------------------------------------------------------ jinvictor's Profile: http://www.excelforum.com/member.php...o&userid=34099 View this thread: http://www.excelforum.com/showthread...hreadid=553118 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
about save or save as
wrap-around
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, _ Cancel As Boolean) With Worksheets("Sheet1") .Unprotect .UsedRange.Value = .UsedRange.Value .Protect End With End Sub -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "jinvictor" wrote in message ... WHY WHEN I RUN THIS VBA, IT SAYS RUN-TIME ERROR '450': wRONG NUMBER OF ARGUMENTS OR INVALID PROPERTY ASSIGNMENT. WHAT CAN I DO? Bob Phillips Wrote: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) With Worksheets("Sheet1") .Unprotect .UsedRange.Value = .UsedRange.Value .Protect End With End Sub -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "jinvictor" wrote in message ... because the workbook is protected, so the code doesnt run properly, what can i do? thanx Bob Phillips Wrote: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) With Worksheets("Sheet1") .UsedRange.Value = .UsedRange.Value End With End Sub 'This is workbook event code. 'To input this code, right click on the Excel icon on the worksheet '(or next to the File menu if you maximise your workbooks), 'select View Code from the menu, and paste the code -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "jinvictor" wrote in message ... what can i do if someone save or save as the workbook, the saved file only got numbers instead fomula, what i mean is when you save the file, you can see all the numbers and you cant put in new data. thanx -- jinvictor ------------------------------------------------------------------------ jinvictor's Profile: http://www.excelforum.com/member.php...o&userid=34099 View this thread: http://www.excelforum.com/showthread...hreadid=553118 -- jinvictor ------------------------------------------------------------------------ jinvictor's Profile: http://www.excelforum.com/member.php...o&userid=34099 View this thread: http://www.excelforum.com/showthread...hreadid=553118 -- jinvictor ------------------------------------------------------------------------ jinvictor's Profile: http://www.excelforum.com/member.php...o&userid=34099 View this thread: http://www.excelforum.com/showthread...hreadid=553118 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Save, save as, page setup dimmed out in unprotected excel sheet? | Excel Discussion (Misc queries) | |||
| How to diasble save and save as menu but allow a save button | Excel Programming | |||
| Totally Disabling (^ save ) (Save as) and Save Icon – Which code do I use: | Excel Programming | |||
| when i save xls file, debug script is running and canno't save fil | Excel Discussion (Misc queries) | |||
| Why system asks me to save change even after I call save method(VB.NET) | Excel Programming | |||
![jinvictor[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
