模仿XColor 功能的加载宏!

mysunway

学生水平较浅,不知.dll应该复制到哪个文夹才对,我试好几个都不是,急等,谢谢谢谢!

mysunway

我还想问的是,这两个有什么区别吗?我指的是"about"和"API"谢谢!

stanleypan

Mysunway : sorry,i can only key in english now. i reassign a new company so i have a little busy now.

as to the question, DLL files can be used after you regist the file. you can find the way used search function.

支持两种方式,1).条件格式,影响Excel 中undo 功能 . 2).XColor 式功能:用API函数绘制实现.功能更强大,自定义选择Color 功能,在支持ROW的功能上,增加对单元格的支持.运行后不影响Excel 中undo 功能.

你的问题

如何安装使用啊？

stanleypan

Set Sh = CreateObject("WScript.Shell") key = "HKEY_CLASSES_ROOT\" x=inputbox("Select your operating system:" & vbnewline & vbnewline & "1. Windows 98" & vbnewline & "2. Windows 2000" & vbnewline & "3. Windows XP" & vbnewline & "4. Other","OS") if isnumeric(x) then if x=1 or x=3 then Sh.RegWrite key & "dllfile\shell\Register\command\", "C:\Windows\System32\Regsvr32.exe " & chr(34) & "%1" & chr(34), "REG_SZ" Sh.RegWrite key & "dllfile\shell\Unregister\command\", "C:\Windows\System32\Regsvr32.exe /u " & chr(34) & "%1" & chr(34), "REG_SZ" msgbox "The context menu has been added.", vbokonly+vbinformation, "Finished" elseif x=2 then Sh.RegWrite key & "dllfile\shell\Register\command\", "C:\WINNT\System32\Regsvr32.exe " & chr(34) & "%1" & chr(34), "REG_SZ" Sh.RegWrite key & "dllfile\shell\Unregister\command\", "C:\WINNT\System32\Regsvr32.exe /u " & chr(34) & "%1" & chr(34), "REG_SZ" msgbox "The context menu has been added.", vbokonly+vbinformation, "Finished" else msgbox "Sorry your OS is not currently supported.", vbokonly+vbinformation, "Sorry" end if else msgbox "Please select an option form the list!", vbokonly+vbinformation, "Error" end if

Save attatch text as RegistDll.VBS. then run this file, select the right operating system.

after that when you right click the XColor.dll file you will find the menu to register.

你的问题

看不懂啊

你的问题

到底该如何安装啊？

stanleypan

加载：在EXCEL界面右键单击工具栏-->自定义-- >命令--选择 工具 -->命令栏-->调出 COM加载项 菜单。点击 COM 加载项菜单，单击 添加，选中 这个.dll,确定,加载完成。 同理:单击 DEL这个DLL就是反注册.

元帅

先谢了

元帅

"调出 COM加载项 菜单"挺难,现在还没找到,是不是2003里不是这个过程?