LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27
Default Spreadsheet in Userform

Hi
I try to use a spreadsheet in a userform but I am experiencing some
problems with it.

when I should show userform, I get the following message.

"program is about to initialize ActiveX controls that may be unsafe. if
you trust the source file, select ok, then the controls will be
initiated with your current settings for the workspace"

Is it possible to avoid this message?

I also have problems with changing the color of the cells and text.

I have tried the following code but the cell or text will always be
black.

UserForm8.Spreadsheet1.Cells(1, 1).Interior.Color = 41
UserForm8.Spreadsheet1.Cells(1, 1).Font.Color = 41

I am grateful if someone can answer my questions.

Thanks in advance.

*** Sent via Developersdex http://www.developersdex.com ***
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
userform for spreadsheet spreadsheets/userforms Excel Discussion (Misc queries) 1 May 20th 05 12:18 PM
Link from Userform to Spreadsheet Richard Excel Programming 3 May 22nd 04 05:54 PM
Userform to spreadsheet Aashi Excel Programming 2 April 25th 04 03:29 PM
spreadsheet on userform alcorjr Excel Programming 2 December 15th 03 07:19 PM
Spreadsheet in an Userform Lukas Rüttimann Excel Programming 0 September 23rd 03 05:06 PM


All times are GMT +1. The time now is 11:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"