Search results for query: *

done!

Hey Thanks kjv1611. I think I have it all set.

I coded something different: Private Sub ComboBox1_Change() 'Unprotect worksheet that contains the charts Worksheets("Supply").Unprotect Password:="Secret" On Error GoTo 1 With Worksheets("Supply").ChartObjects(2).Chart.Axes(xlValue) .MaximumScale = Range("AF2").Value .MinimumScale =...

I have the following code: Private Sub Workbook_Open() Worksheets("Supply").Protect Password:="Secret", _ UserInterFaceOnly:=True End Sub I get a compile error "Expected: named Parameter

Yes. Macros are enabled. The sheet was protected. When I unprotect the sheet the graphs look fine. It must be something to do with the protection. How can I protect the sheet and get the graphs to work?

Hello, I'm new to Excel programming. I inherited a report created using Excel 2003. The charts on the report have a scale that changes based on a combo box value. It works fine in 2003 but in 2007 the scale remains fixed. The line graph on the charts falls off the grid for certain combo box...

Thanks, that worked great. On the form 2 I need to display the savings values for the factory I entered in form 1. Is there a way to tie them together like that?

I now have a switchboard, two forms - one to add the Factory Names and then another to add the savings for each factory and then a report that displays the calculated values for each factory. It is wonderful. Is it feasible to create a button on form 1 so that when a user enters a Factory it...

Thanks! This is a lot of fun. I created the form and it works fine. I found some redundant data in my table. I created another table and placed a relationship between the two tables. Is there any way I can update both table using one form? Thanks again.

Hello, I'm new to Access. I need to build a database and create forms to update the database. I'm using Access 2007. I have built the database with 10 fields. The primary key is the ID field. I want to update, delete or add new records to the database using forms and controls. The updates and...