ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel Spreadsheet Form (https://www.excelbanter.com/excel-discussion-misc-queries/73204-excel-spreadsheet-form.html)

Charlene

Excel Spreadsheet Form
 
The "New" "Delete" and "Restore" buttons are not availalbe in data form from
excel spreadsheet. What am I doing wrong?

Kevin B

Excel Spreadsheet Form
 
I don't think you're doing anything wrong, but it sounds as if the worksheet
is protected. From the menu click TOOLS, select PROTECTION and if the
cascade menu has an UNPROTECT option, the worksheet has protection assigned.
Click UNPROTECT to remove protection. If the worksheet has been protected
with a password you'll need to know the password too.
--
Kevin Backmann


"Charlene" wrote:

The "New" "Delete" and "Restore" buttons are not availalbe in data form from
excel spreadsheet. What am I doing wrong?



All times are GMT +1. The time now is 06:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com