|
|
#1
11-16-2014, 06:46 AM
|
|||
|
|||
selection in other sheets blocked
Hi all!
I have a strange behaviour in Excel: I cannot calculate values either in Excel worksheet nor by VBA. If I have a new workbook with 2 Sheets. Sheet1 is empty, sheet2 has a button linked to the code: Sheets(1).Cells(1,1).Select The error 1004 comes up. "Selection method or range class method failed". The code: Sheets(2).Cells(1,1).Select works fine. I Need EXCEL VBA for my work. Can anyone suggest what's wrong? Just to mention it: macro security settings are low, VBA trust is on. Workbook/worksheet properties are at default setting with EnableSelection on. At a loss, Andrew 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Selection of all Text for a specific page in word is spanning selection across pages
|
ramsgarla | Word VBA | 9 | 12-05-2012 03:23 AM |
| Linking sheets to fetch transactions from sheets to another | waqer | Excel | 4 | 09-01-2011 12:35 PM |
|
Blocked Senders
|
ozarkopa | Outlook | 19 | 03-24-2011 11:42 PM |
| Blocked Excel Attachments | mcconnell | Outlook | 0 | 08-04-2006 03:11 PM |
| Outlook blocked Messages | darmstadtrunner | Office | 5 | 03-08-2006 04:09 PM |
Windows 7 32bit 
Office 2003
Threaded Mode